CMR_XLA_ACCRUAL_CLR_TXNS

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

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'

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'