CMR_XLA_PERIOD_ACCRUAL_TXNS_V
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: VIEW
Columns
Name |
---|
ACCOUNTING_EVENT_ID CMR_PO_DISTRIBUTION_ID TRANSACTION_DATE DESTINATION_TYPE PO_NUMBER PO_SHIPMENT_NUMBER PO_DISTRIBUTION_NUMBER VENDOR_ID VENDOR_NAME VENDOR_SITE_CODE SOLD_TO_BUSINESS_UNIT_ID SOLD_TO_BUSINESS_UNIT_NAME DELIVER_TO_BUSINESS_UNIT_ID DELIVER_TO_BUSINESS_UNIT_NAME INVENTORY_ORGANIZATION_ID INV_ORG_CODE INVENTORY_ITEM_ID ITEM_NUMBER PO_PRICE CURRENCY_CODE NONRECOVERABLE_TAX QUANTITY UOM_CODE |
Query
SQL_Statement |
---|
SELECT cre.accounting_event_id accounting_event_id , cpod.cmr_po_distribution_id cmr_po_distribution_id , cpod.event_date transaction_date , cpod.destination_type_code destination_type , cpod.po_number po_number , cpod.shipment_number po_shipment_number , cpod.distribution_number po_distribution_number , cpod.vendor_id vendor_id , ps.vendor_name vendor_name , pss.vendor_site_code vendor_site_code , cpod.sold_to_business_unit_id sold_to_business_unit_id , haous.name sold_to_business_unit_name , cpod.deliver_to_business_unit_id deliver_to_business_unit_id , haoud.name deliver_to_business_unit_name , cpod.deliver_to_inventory_org_id inventory_organization_id , iop.organization_code inv_org_code , cpod.inventory_item_id inventory_item_id , esi.item_number item_number , cpod.price po_price , cpod.currency_code currency_code , cpod.nonrecoverable_tax nonrecoverable_tax , cpod.quantity_ordered quantity , iuom.unit_of_measure uom_code FROM cmr_purchase_order_dtls cpod , poz_suppliers_v ps , poz_supplier_sites_v pss , egp_system_items_vl esi , inv_org_parameters iop , hr_all_organization_units haous , hr_all_organization_units haoud , cmr_rcv_events cre , inv_units_of_measure_vl iuom WHERE cpod.vendor_id = ps.vendor_id AND cpod.vendor_site_id = pss.vendor_site_id AND esi.inventory_item_id(+) = cpod.inventory_item_id AND esi.organization_id(+) = cpod.deliver_to_inventory_org_id AND cpod.active_flag = 'Y' AND cpod.sold_to_business_unit_id = haous.organization_id AND cpod.deliver_to_business_unit_id = haoud.organization_id AND iop.organization_id = cpod.deliver_to_inventory_org_id AND cre.cmr_po_distribution_id = cpod.cmr_po_distribution_id AND cre.event_class_code = 'PERIOD_END_ACCRUAL' AND iuom.uom_code = cpod.uom_code |