View: CST_XLA_WIP_RCV_REF_V

Product:	BOM - Bills of Material
Description:
Implementation/DBA Data:	APPS.CST_XLA_WIP_RCV_REF_V

View Text

SELECT WT.TRANSACTION_ID WR_WIP_TRANSACTION_ID
, RCV.TRANSACTION_ID WR_RCV_TRANSACTION_ID
, RCV.ORGANIZATION_ID WR_RCV_ORGANIZATION_ID
, RCV.TRANSACTION_TYPE WR_RCV_TRANSACTION_TYPE
, RCV.ATTRIBUTE_CATEGORY WR_RCV_ATTRIBUTE_CATEGORY
, RCV.ATTRIBUTE1 WR_RCV_ATTRIBUTE1
, RCV.ATTRIBUTE2 WR_RCV_ATTRIBUTE2
, RCV.ATTRIBUTE3 WR_RCV_ATTRIBUTE3
, RCV.ATTRIBUTE4 WR_RCV_ATTRIBUTE4
, RCV.ATTRIBUTE5 WR_RCV_ATTRIBUTE5
, RCV.ATTRIBUTE6 WR_RCV_ATTRIBUTE6
, RCV.ATTRIBUTE7 WR_RCV_ATTRIBUTE7
, RCV.ATTRIBUTE8 WR_RCV_ATTRIBUTE8
, RCV.ATTRIBUTE9 WR_RCV_ATTRIBUTE9
, RCV.ATTRIBUTE10 WR_RCV_ATTRIBUTE10
, RCV.ATTRIBUTE11 WR_RCV_ATTRIBUTE11
, RCV.ATTRIBUTE12 WR_RCV_ATTRIBUTE12
, RCV.ATTRIBUTE13 WR_RCV_ATTRIBUTE13
, RCV.ATTRIBUTE14 WR_RCV_ATTRIBUTE14
, RCV.ATTRIBUTE15 WR_RCV_ATTRIBUTE15
, RCV.SUBINVENTORY WR_RCV_SUBINV
, RCV.SOURCE_DOC_QUANTITY WR_RCV_SOURCE_DOC_QTY
, RCV.SOURCE_DOC_UNIT_OF_MEASURE WR_RCV_SOURCE_DOC_UOM
, RCV.BOM_RESOURCE_ID WR_RCV_RESOURCE_ID
, RCV.PROJECT_ID WR_RCV_PROJECT_ID
, RCV.TASK_ID WR_RCV_TASK_ID
, RCV.UNIT_OF_MEASURE WR_RCV_UOM
, RCV.PRIMARY_UNIT_OF_MEASURE WR_RCV_PRIMARY_UOM
, RCV.VENDOR_ID WR_RCV_VENDOR_ID
, RCV.VENDOR_SITE_ID WR_RCV_VENDOR_SITE_ID
, RCV.QUANTITY WR_RCV_QTY
, RCV.PRIMARY_QUANTITY WR_RCV_PRIMARY_QTY
, RCV.JOB_ID WR_RCV_JOB_ID
, RCV.PO_HEADER_ID WR_PO_HEADER_ID
, RCV.PO_LINE_ID WR_PO_LINE_ID
, RCV.PO_DISTRIBUTION_ID WR_PO_DISTRIBUTION_ID
, RCV.PO_RELEASE_ID WR_PO_RELEASE_ID
, RCV.PO_LINE_LOCATION_ID WR_PO_LINE_LOCATION_ID
, POL.ORG_ID WR_PO_OPERATING_UNIT_ID
, POL.ITEM_ID WR_POL_ITEM_ID
, POL.ITEM_DESCRIPTION WR_POL_ITEM_DESCRIPTION
FROM WIP_TRANSACTIONS WT
, RCV_TRANSACTIONS RCV
, PO_LINES_ALL POL
WHERE WT.RCV_TRANSACTION_ID = RCV.TRANSACTION_ID
AND RCV.PO_LINE_ID(+) = POL.PO_LINE_ID

Columns