VRM_REV_DOC_INF_V

Details

• Schema: FUSION

• Object owner: VRM

• Object type: VIEW

Columns

Name
DOCUMENT_ID CUSTOMER_NAME CUSTOMER_NUMBER DOCUMENT_NUMBER DOCUMENT_DATE DOCUMENT_TYPE SOURCE_DOCUMENT_NUMBER SOURCE_DOCUMENT_DATE BUSINESS_UNIT_NAME

Query

SQL_Statement

SELECT rda.REVENUE_DOCUMENT_ID DOCUMENT_ID, pty.party_name CUSTOMER_NAME, ca.account_number CUSTOMER_NUMBER, rda.DOCUMENT_NUMBER DOCUMENT_NUMBER, rda.DOCUMENT_DATE DOCUMENT_DATE, rda.DOCUMENT_TYPE DOCUMENT_TYPE, rda.SOURCE_DOCUMENT_NUMBER, rda.SOURCE_DOCUMENT_DATE, funbu.BU_NAME BUSINESS_UNIT_NAME FROM VRM_REVENUE_DOCUMENTS_ALL rda, hz_cust_accounts ca, hz_parties pty, fun_all_business_units_v funbu WHERE rda.bill_to_customer_id = ca.cust_account_id AND ca.party_id = pty.party_id AND rda.ORG_ID = funbu.bu_id