CMR_XLA_ACCRUAL_CLR_TXNS_V
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: VIEW
Columns
Name |
---|
ACCOUNTING_EVENT_ID ACCRUAL_CLR_ID TRANSACTION_DATE PO_NUMBER PO_DISTRIBUTION_NUMBER VENDOR_ID VENDOR_NAME VENDOR_SITE_ID VENDOR_SITE_CODE ACCTUAL_CLR_AMT INVENTORY_ITEM_ID ITEM_NUMBER INV_ORG_ID INV_ORG_CODE DESTINATION_TYPE_CODE ACCRUAL_CLR_RULE_NAME ACCRUAL_CLR_REASON_DESC CURRENCY_CODE SOLD_TO_BUSINESS_UNIT_ID SOLD_TO_BUSINESS_UNIT_NAME CMR_ACCRUAL_AMT AP_ACCRUAL_AMT |
Query
SQL_Statement |
---|
SELECT cre.accounting_event_id accounting_event_id , caca.accrual_clr_id accrual_clr_id , caca.latest_txn_date transaction_date , cpod.po_number po_number , cpod.distribution_number po_distribution_number , cpod.vendor_id vendor_id , ps.vendor_name vendor_name , cpod.vendor_site_id vendor_site_id , pss.vendor_site_code vendor_site_code , caca.accrual_clr_amt acctual_clr_amt , caca.inventory_item_id inventory_item_id , esi.item_number item_number , caca.inventory_organization_id inv_org_id , iop.organization_code inv_org_code , caca.destination_type_code destination_type_code , caca.accrual_clr_rule_name accrual_clr_rule_name , caca.accrual_clr_reason_desc accrual_clr_reason_desc , cpod.currency_code currency_code , caca.sold_to_business_unit_id sold_to_business_unit_id , haou.name sold_to_business_unit_name , caca.cmr_accrual_amt cmr_accrual_amt , caca.ap_accrual_amt ap_accrual_amt FROM cmr_accrual_clr_amts caca , hr_all_organization_units haou , inv_org_parameters iop , egp_system_items_vl esi , cmr_purchase_order_dtls cpod , poz_suppliers_v ps , poz_supplier_sites_v pss , cmr_rcv_events cre WHERE caca.sold_to_business_unit_id = haou.organization_id AND caca.inventory_item_id = esi.inventory_item_id(+) AND caca.inventory_organization_id = esi.organization_id(+) AND caca.inventory_organization_id = iop.organization_id AND cpod.cmr_po_distribution_id = caca.cmr_po_distribution_id AND ps.vendor_id = cpod.vendor_id AND pss.vendor_id = cpod.vendor_id AND pss.vendor_site_id = cpod.vendor_site_id AND cpod.active_flag = 'Y' AND cre.cmr_po_distribution_id = cpod.cmr_po_distribution_id AND cre.event_source_id = caca.accrual_clr_id AND cre.event_class_code = 'ACCRUAL_CLEARING' |