VIEW: APPS.CST_XLA_WIP_RCV_REF_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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