1. Tables and Views for Financials
  2. VRM_XLA_BILL_TO_CUSTOMERS_V

VRM_XLA_BILL_TO_CUSTOMERS_V

Details

  • Schema: FUSION

  • Object owner: VRM

  • Object type: VIEW

Columns

Name

H_BILL_TO_SITE_REV_CCID

L_BILL_TO_SITE_REV_CCID

H_BILL_TO_CUST_CLASSIFICATION

L_BILL_TO_CUST_CLASSIFICATION

EVENT_ID

LINE_NUMBER

LEDGER_ID

Query

SQL_Statement

SELECT

/*+INDEX (l VRM_XLA_IFRS15_EXTRACT_GT_N1)*/

refacc_h.REV_CCID H_BILL_TO_SITE_REV_CCID,

refacc_l.REV_CCID L_BILL_TO_SITE_REV_CCID,

vsd.bill_to_cust_classification H_BILL_TO_CUST_CLASSIFICATION,

vsdl.bill_to_cust_classification L_BILL_TO_CUST_CLASSIFICATION,

l.event_id EVENT_ID ,

l.line_number LINE_NUMBER ,

l.ledger_id LEDGER_ID

FROM AR_REF_ACCOUNTS_ALL refacc_h,

AR_REF_ACCOUNTS_ALL refacc_l,

VRM_XLA_IFRS15_EXTRACT_GT l,

VRM_SOURCE_DOCUMENTS vsd,

VRM_SOURCE_DOC_LINES vsdl

WHERE refacc_h.SOURCE_REF_ACCOUNT_ID(+) = l.h_bill_site_use_id

AND refacc_h.source_ref_table (+) = 'HZ_CUST_SITE_USES_ALL'

AND refacc_h.bu_id(+) = l.bu_id

AND refacc_l.SOURCE_REF_ACCOUNT_ID(+) = l.l_bill_site_use_id

AND refacc_l.source_ref_table (+) = 'HZ_CUST_SITE_USES_ALL'

AND refacc_l.bu_id(+) = l.bu_id

AND vsd.document_id = l.document_id

AND vsdl.document_line_id = l.document_line_id

AND l.level_code = 'L'