View: POS_LINES_V

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	APPS.POS_LINES_V

View Text

SELECT RTI.PACKING_SLIP
, RTI.COMMENTS
, CONTAINER_NUM
, RTI.COUNTRY_OF_ORIGIN_CODE
, BARCODE_LABEL
, TRUCK_NUM
, DOCUMENT_LINE_NUM
, ITEM_DESCRIPTION
, VENDOR_LOT_NUM
, USE_MTL_SERIAL
, VENDOR_CUM_SHIPPED_QTY
, DELIVER_TO_LOCATION_CODE
, DELIVER_TO_PERSON_NAME
, DESTINATION_TYPE_CODE
, LOCATOR
, RTI.NUM_OF_CONTAINERS
, PO_REVISION_NUM
, RMA_REFERENCE
, SUBINVENTORY
, TRANSFER_COST
, ACTUAL_COST
, TRANSPORTATION_ACCOUNT_ID
, TRANSPORTATION_COST
, RTI.PO_HEADER_ID
, RTI.PO_LINE_ID
, PO_LINE_LOCATION_ID
, RTI.QUANTITY
, UNIT_OF_MEASURE
, UOM_CODE
, ITEM_ID
, SHIP_TO_LOCATION_CODE
, TO_ORGANIZATION_ID
, PO_UNIT_PRICE
, RTI.VENDOR_ID
, VENDOR_ITEM_NUM
, 'VENDOR_SITE_CODE' VENDOR_SITE_CODE
, RTI.VENDOR_SITE_ID
, 'ATTRIBUTE15' ATTRIBUTE15
, RTI.VENDOR_NAME
, RHI.SHIPMENT_NUM
, 'LINE_SEQUENCE' LINE_SEQUENCE
, DECODE(PRL.PO_RELEASE_ID
, NULL
, POH.SEGMENT1
, POH.SEGMENT1 || '-' || TO_CHAR(PRL.RELEASE_NUM)) PO_NUMBER
, 'ITEM_NUMBER' ITEM_NUMBER
, 'QUANTITY_INVOICED' QUANTITY_INVOICED
, 'TAXABLE_FLAG' TAXABLE_FLAG
, RTI.TAX_NAME
, RTI.TAX_AMOUNT
, 'CURRENCY_CODE' CURRENCY_CODE
, 'CONVERSION_RATE' CONVERSION_RATE
, 'CONVERSION_DATE' CONVERSION_DATE
, 'LINE_IDENTIFIER' LINE_IDENTIFIER
, TER.TERRITORY_CODE COUNTRY_OF_ORIGIN_DISPLAYED
, 'DUE_DATE' DUE_DATE
, PLL.QUANTITY QUANTITY_ORDERED
, PLL.QUANTITY_RECEIVED
, RTI.HEADER_INTERFACE_ID
, RTI.PROCESSING_STATUS_CODE
, RTI.TRANSACTION_STATUS_CODE
FROM RCV_TRANSACTIONS_INTERFACE RTI
, RCV_HEADERS_INTERFACE RHI
, PO_HEADERS_ALL POH
, FND_TERRITORIES_VL TER
, PO_LINE_LOCATIONS_ALL PLL
, PO_RELEASES_ALL PRL
WHERE POH.PO_HEADER_ID (+) = RTI.PO_HEADER_ID
AND TER.TERRITORY_SHORT_NAME (+) = RTI.COUNTRY_OF_ORIGIN_CODE
AND RHI.HEADER_INTERFACE_ID = RTI.HEADER_INTERFACE_ID
AND PLL.LINE_LOCATION_ID = RTI.PO_LINE_LOCATION_ID
AND PLL.PO_RELEASE_ID = PRL.PO_RELEASE_ID(+) UNION SELECT RSL.PACKING_SLIP
, RSL.COMMENTS
, CONTAINER_NUM
, RSL.COUNTRY_OF_ORIGIN_CODE
, RSL.BAR_CODE_LABEL BARCODE_LABEL
, TRUCK_NUM
, LINE_NUM DOCUMENT_LINE_NUM
, ITEM_DESCRIPTION
, VENDOR_LOT_NUM
, TO_NUMBER('') USE_MTL_SERIAL
, TO_NUMBER('') VENDOR_CUM_SHIPPED_QTY
, '' DELIVER_TO_LOCATION_CODE
, '' DELIVER_TO_PERSON_NAME
, DESTINATION_TYPE_CODE
, '' LOCATOR
, TO_NUMBER('') NUM_OF_CONTAINERS
, TO_NUMBER('') PO_REVISION_NUM
, '' RMA_REFERENCE
, '' SUBINVENTORY
, TRANSFER_COST
, TO_NUMBER('') ACTUAL_COST
, TRANSPORTATION_ACCOUNT_ID
, TRANSPORTATION_COST
, RSL.PO_HEADER_ID
, RSL.PO_LINE_ID
, PO_LINE_LOCATION_ID
, RSL.QUANTITY_SHIPPED QUANTITY
, UNIT_OF_MEASURE
, '' UOM_CODE
, ITEM_ID
, HRL.LOCATION_CODE SHIP_TO_LOCATION_CODE
, TO_ORGANIZATION_ID
, SHIPMENT_UNIT_PRICE PO_UNIT_PRICE
, POH.VENDOR_ID
, VENDOR_ITEM_NUM
, 'VENDOR_SITE_CODE' VENDOR_SITE_CODE
, PVS.VENDOR_SITE_ID
, 'ATTRIBUTE15' ATTRIBUTE15
, POV.VENDOR_NAME
, RSH.SHIPMENT_NUM
, 'LINE_SEQUENCE' LINE_SEQUENCE
, DECODE(PRL.PO_RELEASE_ID
, NULL
, POH.SEGMENT1
, POH.SEGMENT1 || '-' || TO_CHAR(PRL.RELEASE_NUM)) PO_NUMBER
, 'ITEM_NUMBER' ITEM_NUMBER
, 'QUANTITY_INVOICED' QUANTITY_INVOICED
, 'TAXABLE_FLAG' TAXABLE_FLAG
, RSL.TAX_NAME
, RSL.TAX_AMOUNT
, 'CURRENCY_CODE' CURRENCY_CODE
, 'CONVERSION_RATE' CONVERSION_RATE
, 'CONVERSION_DATE' CONVERSION_DATE
, 'LINE_IDENTIFIER' LINE_IDENTIFIER
, TER.TERRITORY_CODE COUNTRY_OF_ORIGIN_DISPLAYED
, 'DUE_DATE' DUE_DATE
, PLL.QUANTITY QUANTITY_ORDERED
, PLL.QUANTITY_RECEIVED
, RSL.SHIPMENT_HEADER_ID HEADER_INTERFACE_ID
, 'PROCESSING_STATUS_CODE' PROCESSING_STATUS_CODE
, 'TRANSACTION_STATUS_CODE' TRANSACTION_STATUS_CODE
FROM RCV_SHIPMENT_LINES RSL
, RCV_SHIPMENT_HEADERS RSH
, PO_HEADERS_ALL POH
, FND_TERRITORIES_VL TER
, PO_LINE_LOCATIONS_ALL PLL
, PO_VENDORS POV
, PO_VENDOR_SITES_ALL PVS
, HR_LOCATIONS_ALL HRL
, PO_RELEASES_ALL PRL
WHERE POH.PO_HEADER_ID (+) = RSL.PO_HEADER_ID
AND TER.TERRITORY_SHORT_NAME (+) = RSL.COUNTRY_OF_ORIGIN_CODE
AND RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID
AND PLL.LINE_LOCATION_ID = RSL.PO_LINE_LOCATION_ID
AND POH.VENDOR_ID = POV.VENDOR_ID
AND PVS.VENDOR_SITE_ID (+) = POH.VENDOR_SITE_ID
AND HRL.LOCATION_ID (+) = RSL.SHIP_TO_LOCATION_ID
AND PLL.PO_RELEASE_ID = PRL.PO_RELEASE_ID(+)

Columns