CMR_XLA_PO_INTRANSIT_TXNS

Details

Schema: FUSION
Object owner: CMR
Object type: VIEW

Columns

Name
ACCOUNTING_EVENT_ID SHIPMENT_LINE_ID TRANSACTION_DATE TRANSACTION_TYPE PO_NUMBER RECEIPT_NUMBER VENDOR_ID QUANTITY UOM_CODE PO_PRICE CURRENCY_CODE INVENTORY_ITEM_ID ITEM_NUMBER INVENTORY_ORGANIZATION_ID INV_ORG_CODE BUSINESS_UNIT_ID BUSINESS_UNIT_NAME VENDOR_NAME VENDOR_SITE_CODE

Name

ACCOUNTING_EVENT_ID

SHIPMENT_LINE_ID

TRANSACTION_DATE

TRANSACTION_TYPE

PO_NUMBER

RECEIPT_NUMBER

VENDOR_ID

QUANTITY

UOM_CODE

PO_PRICE

CURRENCY_CODE

INVENTORY_ITEM_ID

ITEM_NUMBER

INVENTORY_ORGANIZATION_ID

INV_ORG_CODE

BUSINESS_UNIT_ID

BUSINESS_UNIT_NAME

VENDOR_NAME

VENDOR_SITE_CODE

Query

SQL_Statement
SELECT cre.accounting_event_id accounting_event_id , caia.SHIPMENT_LINE_ID SHIPMENT_LINE_ID , cre.transaction_date transaction_date , txntypes.transaction_type_name transaction_type , caia.po_number po_number , caia.receipt_number receipt_number , caia.vendor_id vendor_id , decode(caia.reversal_quantity, 0, caia.intransit_quantity, caia.reversal_quantity) quantity , caia.SOURCE_DOC_UOM_CODE uom_code , caia.po_price + nvl(caia.NR_TAX,0) po_price , caia.currency_code currency_code , cre.inventory_item_id inventory_item_id , esi.item_number item_number , cre.inventory_org_id inventory_organization_id , iop.organization_code inv_org_code , cre.business_unit_id business_unit_id , haous.name business_unit_name , ps.vendor_name vendor_name , pss.vendor_site_code vendor_site_code FROM fusion.cmr_asn_intransit_amts caia , fusion.egp_system_items_vl esi , fusion.inv_org_parameters iop , fusion.cmr_rcv_events cre , fusion.inv_units_of_measure_vl iuom , fusion.hr_all_organization_units haous , fusion.poz_suppliers_v ps , fusion.poz_supplier_sites_v pss , FUSION.cmr_transaction_types_vl txntypes WHERE cre.event_transaction_id = caia.asn_intransit_id AND esi.inventory_item_id(+) = cre.inventory_item_id AND cre.inventory_org_id = esi.organization_id(+) AND cre.inventory_org_id = iop.organization_id AND cre.event_type_code = 'PO_INTRANSIT' AND cre.EVENT_TXN_TABLE_NAME = 'CMR_ASN_INTRANSIT_AMTS' AND iuom.uom_code (+) = cre.source_doc_uom_code AND haous.organization_id = cre.business_unit_id AND caia.vendor_id = ps.vendor_id AND caia.vendor_site_id = pss.vendor_site_id AND cre.transaction_type_code = txntypes.transaction_type_code

SQL_Statement

SELECT cre.accounting_event_id accounting_event_id

, caia.SHIPMENT_LINE_ID SHIPMENT_LINE_ID

, cre.transaction_date transaction_date

, txntypes.transaction_type_name transaction_type

, caia.po_number po_number

, caia.receipt_number receipt_number

, caia.vendor_id vendor_id

, decode(caia.reversal_quantity, 0, caia.intransit_quantity, caia.reversal_quantity) quantity

, caia.SOURCE_DOC_UOM_CODE uom_code

, caia.po_price + nvl(caia.NR_TAX,0) po_price

, caia.currency_code currency_code

, cre.inventory_item_id inventory_item_id

, esi.item_number item_number

, cre.inventory_org_id inventory_organization_id

, iop.organization_code inv_org_code

, cre.business_unit_id business_unit_id

, haous.name business_unit_name

, ps.vendor_name vendor_name

, pss.vendor_site_code vendor_site_code

FROM fusion.cmr_asn_intransit_amts caia

, fusion.egp_system_items_vl esi

, fusion.inv_org_parameters iop

, fusion.cmr_rcv_events cre

, fusion.inv_units_of_measure_vl iuom

, fusion.hr_all_organization_units haous

, fusion.poz_suppliers_v ps

, fusion.poz_supplier_sites_v pss

, FUSION.cmr_transaction_types_vl txntypes

WHERE cre.event_transaction_id = caia.asn_intransit_id

AND esi.inventory_item_id(+) = cre.inventory_item_id

AND cre.inventory_org_id = esi.organization_id(+)

AND cre.inventory_org_id = iop.organization_id

AND cre.event_type_code = 'PO_INTRANSIT'

AND cre.EVENT_TXN_TABLE_NAME = 'CMR_ASN_INTRANSIT_AMTS'

AND iuom.uom_code (+) = cre.source_doc_uom_code

AND haous.organization_id = cre.business_unit_id

AND caia.vendor_id = ps.vendor_id

AND caia.vendor_site_id = pss.vendor_site_id

AND cre.transaction_type_code = txntypes.transaction_type_code