PJB_XLA_REFACCT_SITEUSE_V

Details

• Schema: FUSION

• Object owner: PJB

• Object type: VIEW

Columns

Name
BILL_TO_SITE_USE_ID CONTRACT_ORGANIZATION_ID BILLTO_USES_CLEARING_CCID BILLTO_USES_FREIGHT_CCID BILLTO_USES_REC_CCID BILLTO_USES_REV_CCID BILLTO_USES_TAX_CCID BILLTO_USES_UNBILLED_CCID BILLTO_USES_UNEARNED_CCID

Query

SQL_Statement

SELECT RefAcct.SOURCE_REF_ACCOUNT_ID Bill_To_Site_Use_id, RefAcct.BU_ID CONTRACT_ORGANIZATION_ID, RefAcct.CLEARING_CCID billto_uses_clearing_ccid, RefAcct.FREIGHT_CCID billto_uses_freight_ccid , RefAcct.REC_CCID billto_uses_rec_ccid , RefAcct.REV_CCID billto_uses_rev_ccid , RefAcct.TAX_CCID billto_uses_tax_ccid , RefAcct.UNBILLED_CCID billto_uses_unbilled_ccid , RefAcct.UNEARNED_CCID billto_uses_unearned_ccid FROM AR_REF_ACCOUNTS_ALL RefAcct WHERE RefAcct.SOURCE_REF_TABLE = 'HZ_CUST_SITE_USES_ALL'