View: CST_RCV_RAE_V

Product:	BOM - Bills of Material
Description:	View on the Receiving Accounting events table. Selects information related to the receiving accounting event along with details of the receiving transaction, inventory organization, purchase order document, shipment, vendor etc
Implementation/DBA Data:	APPS.CST_RCV_RAE_V

View Text

SELECT RAE.ROWID
, RAE.ORGANIZATION_ID
, RAE.ORG_ID
, COD.ORGANIZATION_NAME
, COD.ORGANIZATION_CODE
, COD.SET_OF_BOOKS_ID
, RAE.RCV_TRANSACTION_ID
, RAE.ACCOUNTING_EVENT_ID
, RAE.EVENT_TYPE_ID
, DECODE(RAE.EVENT_TYPE_ID
, 15
, RAET.DESCRIPTION
, 16
, RAET.DESCRIPTION
, 17
, RAET.DESCRIPTION
, RAET.EVENT_TYPE_NAME) EVENT_TYPE_NAME
, RAE.TRANSACTION_DATE
, RAE.TRANSACTION_QUANTITY
, MUOMTXN.UOM_CODE
, RAE.PRIMARY_QUANTITY
, MUOMPRIM.UOM_CODE
, RT.PO_HEADER_ID
, NVL(POH.CLM_DOCUMENT_NUMBER
, POH.SEGMENT1)
, RT.PO_LINE_ID
, NVL(POL.LINE_NUM_DISPLAY
, TO_CHAR(POL.LINE_NUM))
, RAE.PO_DISTRIBUTION_ID
, RAE.PO_RELEASE_ID
, POR.RELEASE_NUM
, PRH.REQUISITION_HEADER_ID
, PRH.SEGMENT1
, PRL.REQUISITION_LINE_ID
, PRL.LINE_NUM
, POH.VENDOR_ID
, POV.VENDOR_NAME
, POH.VENDOR_SITE_ID
, PVS.VENDOR_SITE_CODE
, RSH.RECEIPT_NUM
, RSH.SHIPMENT_NUM
, RSH.SHIPMENT_HEADER_ID
, RSL.LINE_NUM
, RSL.SHIPMENT_LINE_ID
, RT.LOCATION_ID
, POL.ITEM_ID
, NVL(MSI.DESCRIPTION
, POL.ITEM_DESCRIPTION)
, RSL.ITEM_REVISION
, RAE.UNIT_PRICE
, RAE.PRIOR_UNIT_PRICE
, RAE.UNIT_LANDED_COST
, RAE.INTERCOMPANY_PRICING_OPTION
, RAE.TRANSACTION_AMOUNT
, RAE.NR_TAX
, RAE.REC_TAX
, RAE.NR_TAX_AMOUNT
, RAE.REC_TAX_AMOUNT
, RAE.PRIOR_NR_TAX
, RAE.PRIOR_REC_TAX
, RAE.CURRENCY_CODE
, RAE.CURRENCY_CONVERSION_TYPE
, RAE.CURRENCY_CONVERSION_RATE
, RAE.CURRENCY_CONVERSION_DATE
, RAE.ACCOUNTED_FLAG
, RAE.PROCUREMENT_ORG_FLAG
, RAE.CROSS_OU_FLAG
, RAE.TRX_FLOW_HEADER_ID
, RAE.INVOICED_FLAG
, RAE.PA_ADDITION_FLAG
, RAE.LAST_UPDATE_DATE
, RAE.LAST_UPDATED_BY
, RAE.CREATION_DATE
, RAE.CREATED_BY
, RAE.LAST_UPDATE_LOGIN
, RAE.REQUEST_ID
, RAE.PROGRAM_APPLICATION_ID
, RAE.PROGRAM_ID
, RAE.PROGRAM_UDPATE_DATE
FROM RCV_ACCOUNTING_EVENTS RAE
, RCV_TRANSACTIONS RT
, PO_HEADERS POH
, PO_LINES POL
, PO_LINE_LOCATIONS POLL
, PO_REQUISITION_HEADERS PRH
, PO_REQUISITION_LINES PRL
, RCV_SHIPMENT_HEADERS RSH
, RCV_SHIPMENT_LINES RSL
, PO_VENDORS POV
, PO_VENDOR_SITES_ALL PVS
, RCV_ACCOUNTING_EVENT_TYPES RAET
, MTL_SYSTEM_ITEMS_VL MSI
, CST_ORGANIZATION_DEFINITIONS COD
, MTL_UNITS_OF_MEASURE MUOMTXN
, MTL_UNITS_OF_MEASURE MUOMPRIM
, PO_RELEASES POR
WHERE RAE.RCV_TRANSACTION_ID = RT.TRANSACTION_ID
AND PRL.REQUISITION_LINE_ID(+) = RT.REQUISITION_LINE_ID
AND PRH.REQUISITION_HEADER_ID(+) = PRL.REQUISITION_HEADER_ID
AND RAE.PO_HEADER_ID = POH.PO_HEADER_ID
AND RAE.PO_LINE_ID = POL.PO_LINE_ID
AND RAE.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID
AND RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID
AND RSL.SHIPMENT_LINE_ID = RT.SHIPMENT_LINE_ID
AND RSH.SHIPMENT_HEADER_ID = RT.SHIPMENT_HEADER_ID
AND COD.ORGANIZATION_ID = RAE.ORGANIZATION_ID
AND RAE.EVENT_TYPE_ID = RAET.EVENT_TYPE_ID
AND POV.VENDOR_ID(+) = RT.VENDOR_ID
AND PVS.VENDOR_SITE_ID(+) = POH.VENDOR_SITE_ID
AND MSI.INVENTORY_ITEM_ID(+) = RAE.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID (+) = RAE.ORGANIZATION_ID
AND NVL(POLL.ACCRUE_ON_RECEIPT_FLAG
, 'N') = 'Y'
AND RAE.EVENT_TYPE_ID NOT IN (18
, 19
, 20
, 14)
AND MUOMTXN.UNIT_OF_MEASURE(+) = RAE.TRANSACTION_UNIT_OF_MEASURE
AND MUOMPRIM.UNIT_OF_MEASURE(+) = RAE.PRIMARY_UNIT_OF_MEASURE
AND POR.PO_RELEASE_ID (+) = RAE.PO_RELEASE_ID
AND POL.ITEM_ID(+) = RAE.INVENTORY_ITEM_ID
AND RT.PO_HEADER_ID IS NOT NULL
AND POH.PO_HEADER_ID = RT.PO_HEADER_ID
AND POL.PO_LINE_ID = RT.PO_LINE_ID
AND RT.DESTINATION_TYPE_CODE != 'INVENTORY' UNION ALL SELECT RAE.ROWID
, RAE.ORGANIZATION_ID
, RAE.ORG_ID
, COD.ORGANIZATION_NAME
, COD.ORGANIZATION_CODE
, COD.SET_OF_BOOKS_ID
, RAE.RCV_TRANSACTION_ID
, RAE.ACCOUNTING_EVENT_ID
, RAE.EVENT_TYPE_ID
, RAET.EVENT_TYPE_NAME
, RAE.TRANSACTION_DATE
, RAE.TRANSACTION_QUANTITY
, MUOMTXN.UOM_CODE
, RAE.PRIMARY_QUANTITY
, MUOMPRIM.UOM_CODE
, POH.PO_HEADER_ID
, NVL(POH.CLM_DOCUMENT_NUMBER
, POH.SEGMENT1)
, POL.PO_LINE_ID
, NVL(POL.LINE_NUM_DISPLAY
, TO_CHAR(POL.LINE_NUM))
, RAE.PO_DISTRIBUTION_ID
, RAE.PO_RELEASE_ID
, POR.RELEASE_NUM
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, POH.VENDOR_ID
, POV.VENDOR_NAME
, POH.VENDOR_SITE_ID
, PVS.VENDOR_SITE_CODE
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, RAE.INVENTORY_ITEM_ID
, NVL(MSI.DESCRIPTION
, POL.ITEM_DESCRIPTION)
, TO_CHAR(NULL)
, RAE.UNIT_PRICE
, RAE.PRIOR_UNIT_PRICE
, RAE.UNIT_LANDED_COST
, RAE.INTERCOMPANY_PRICING_OPTION
, RAE.TRANSACTION_AMOUNT
, RAE.NR_TAX
, RAE.REC_TAX
, RAE.NR_TAX_AMOUNT
, RAE.REC_TAX_AMOUNT
, RAE.PRIOR_NR_TAX
, RAE.PRIOR_REC_TAX
, RAE.CURRENCY_CODE
, RAE.CURRENCY_CONVERSION_TYPE
, RAE.CURRENCY_CONVERSION_RATE
, RAE.CURRENCY_CONVERSION_DATE
, RAE.ACCOUNTED_FLAG
, RAE.PROCUREMENT_ORG_FLAG
, RAE.CROSS_OU_FLAG
, RAE.TRX_FLOW_HEADER_ID
, RAE.INVOICED_FLAG
, RAE.PA_ADDITION_FLAG
, RAE.LAST_UPDATE_DATE
, RAE.LAST_UPDATED_BY
, RAE.CREATION_DATE
, RAE.CREATED_BY
, RAE.LAST_UPDATE_LOGIN
, RAE.REQUEST_ID
, RAE.PROGRAM_APPLICATION_ID
, RAE.PROGRAM_ID
, RAE.PROGRAM_UDPATE_DATE
FROM RCV_ACCOUNTING_EVENTS RAE
, PO_HEADERS POH
, PO_LINES POL
, PO_LINE_LOCATIONS POLL
, PO_VENDORS POV
, PO_VENDOR_SITES_ALL PVS
, RCV_ACCOUNTING_EVENT_TYPES RAET
, MTL_SYSTEM_ITEMS_VL MSI
, CST_ORGANIZATION_DEFINITIONS COD
, MTL_UNITS_OF_MEASURE MUOMTXN
, MTL_UNITS_OF_MEASURE MUOMPRIM
, PO_RELEASES POR
WHERE RAE.PO_HEADER_ID = POH.PO_HEADER_ID
AND RAE.PO_LINE_ID = POL.PO_LINE_ID
AND RAE.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID
AND COD.ORGANIZATION_ID = RAE.ORGANIZATION_ID
AND RAE.EVENT_TYPE_ID = RAET.EVENT_TYPE_ID
AND POV.VENDOR_ID = POH.VENDOR_ID
AND PVS.VENDOR_SITE_ID = POH.VENDOR_SITE_ID
AND MSI.INVENTORY_ITEM_ID(+) = RAE.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID (+) = RAE.ORGANIZATION_ID
AND NVL(POLL.ACCRUE_ON_RECEIPT_FLAG
, 'N') = 'N'
AND RAE.EVENT_TYPE_ID IN (13
, 14)
AND MUOMTXN.UNIT_OF_MEASURE(+) = RAE.TRANSACTION_UNIT_OF_MEASURE
AND MUOMPRIM.UNIT_OF_MEASURE(+) = RAE.PRIMARY_UNIT_OF_MEASURE
AND POR.PO_RELEASE_ID (+) = RAE.PO_RELEASE_ID

Columns