View: CST_RCV_RAE_V

Product:	BOM - Bills of Material
Description:
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
, POH.SEGMENT1
, RT.PO_LINE_ID
, 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
, POH.SEGMENT1
, POL.PO_LINE_ID
, 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
AND POL.ITEM_ID(+) = RAE.INVENTORY_ITEM_ID

Columns