CMR_XLA_INVOICE_ADJ_TXNS_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
ACCOUNTING_EVENT_ID CMR_AP_INVOICE_DIST_ID TRANSACTION_DATE PO_NUMBER PO_SHIPMENT_NUMBER PO_DISTRIBUTION_NUMBER INVOICE_NUMBER VENDOR_ID VENDOR_NAME VENDOR_SITE_ID VENDOR_SITE_CODE QUANTITY UOM_CODE PO_PRICE CURRENCY_CODE INVENTORY_ITEM_ID ITEM_NUMBER INV_ORG_ID INV_ORG_CODE BUSINESS_UNIT_ID BUSINESS_UNIT_NAME DISTRIBUTION_MATCH_TYPE FINAL_MATCH_FLAG INVOICE_SOURCE

Query

SQL_Statement

SELECT cre.accounting_event_id accounting_event_id , ciad.cmr_ap_invoice_dist_id cmr_ap_invoice_dist_id , cpod.event_date transaction_date , cpod.po_number po_number , cpod.shipment_number po_shipment_number , cpod.distribution_number po_distribution_number , ciad.invoice_number invoice_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 , ciad.invoice_qty quantity , ciad.unit_of_measure uom_code , cpod.price + nvl(cpod.nonrecoverable_tax,0) po_price , cpod.currency_code currency_code , cpod.inventory_item_id inventory_item_id , esi.item_number item_number , cpod.deliver_to_inventory_org_id inv_org_id , iop.organization_code inv_org_code , cpod.sold_to_business_unit_id business_unit_id , haous.name business_unit_name , ciad.distribution_match_type distribution_match_type , ciad.final_match_flag final_match_flag , ciad.invoice_source invoice_source FROM cmr_ap_invoice_dtls ciad , cmr_purchase_order_dtls cpod , egp_system_items_vl esi , inv_org_parameters iop , hr_all_organization_units haous , poz_suppliers_v ps , poz_supplier_sites_v pss , cmr_rcv_events cre WHERE cpod.inventory_item_id = esi.inventory_item_id(+) AND cpod.deliver_to_inventory_org_id = esi.organization_id(+) AND iop.organization_id = cpod.deliver_to_inventory_org_id AND haous.organization_id = cpod.sold_to_business_unit_id AND cpod.vendor_id = ps.vendor_id AND cpod.vendor_id = pss.vendor_id AND cpod.vendor_site_id = pss.vendor_site_id AND cpod.active_flag = 'Y' AND cpod.cmr_po_distribution_id = ciad.cmr_po_distribution_id AND cre.cmr_po_distribution_id = cpod.cmr_po_distribution_id AND cre.event_source_id = ciad.cmr_ap_invoice_dist_id AND cre.event_class_code= 'INVOICE_PRICE_ADJUSTMENT'