View: RCV_FTE_LINES_V

Product:	PO - Purchasing
Description:	Transaction Lines for logistics
Implementation/DBA Data:	APPS.RCV_FTE_LINES_V

View Text

SELECT RSE.SHIPMENT_HEADER_ID
, RSE.SHIPMENT_LINE_ID
, RSE.ASN_LINE_FLAG
, RSE.PO_HEADER_ID
, RSE.PO_LINE_ID
, RSE.PO_LINE_LOCATION_ID
, RSE.ITEM_ID
, RSE.ITEM_REVISION
, RSE.ITEM_DESCRIPTION
, RSE.TRUCK_NUM
, RSE.QUANTITY_SHIPPED
, RSE.QUANTITY_RECEIVED
, RSE.SHIP_TO_LOCATION_ID
, RSE.PACKING_SLIP
, RSE.PO_RELEASE_ID
, RSE.CONTAINER_NUM
, RSE.LINE_NUM
, RSE.SHIPMENT_UNIT_PRICE
, RSE.SECONDARY_QUANTITY_SHIPPED
, RSE.SECONDARY_QUANTITY_RECEIVED
, PHL.SEGMENT1
, PLL.SHIPMENT_NUM
, PLL.SHIP_TO_LOCATION_ID
, POL.LINE_NUM
, RSE.LAST_UPDATE_DATE
, RSE.LAST_UPDATED_BY
, RSE.CREATION_DATE
, RSE.LAST_UPDATE_LOGIN
, RSE.CREATED_BY
, RSE.TO_ORGANIZATION_ID
, MUL.UOM_CODE
, MUL1.UOM_CODE
, MUL.UNIT_OF_MEASURE
, MUL1.UNIT_OF_MEASURE
, PHL.REVISION_NUM
, RSE.ASN_LPN_ID
, RSH.SHIP_FROM_LOCATION_ID
FROM RCV_SHIPMENT_LINES RSE
, PO_HEADERS_ALL PHL
, PO_LINE_LOCATIONS_ALL PLL
, PO_LINES_ALL POL
, PO_LINE_TYPES_B PLB
, MTL_UNITS_OF_MEASURE_VL MUL
, MTL_UNITS_OF_MEASURE_VL MUL1
, RCV_SHIPMENT_HEADERS RSH
WHERE RSE.PO_HEADER_ID = PHL.PO_HEADER_ID
AND RSE.PO_LINE_LOCATION_ID = PLL.LINE_LOCATION_ID
AND RSE.PO_LINE_ID = POL.PO_LINE_ID
AND RSE.UNIT_OF_MEASURE = MUL.UNIT_OF_MEASURE (+)
AND RSE.UNIT_OF_MEASURE = MUL1.UNIT_OF_MEASURE (+)
AND PHL.TYPE_LOOKUP_CODE IN ( 'STANDARD'
, 'BLANKET')
AND PHL.SHIPPING_CONTROL IS NOT NULL
AND POL.LINE_TYPE_ID = PLB.LINE_TYPE_ID
AND PLB.ORDER_TYPE_LOOKUP_CODE = 'QUANTITY'
AND RSE.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID

Columns