FND Design Data [Home] [Help]

View: RCV_FTE_LINES_V

Product: PO - Purchasing
Description: Transaction Lines for logistics
Implementation/DBA Data: ViewAPPS.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

Name
SHIPMENT_HEADER_ID
SHIPMENT_LINE_ID
ASN_LINE_FLAG
PO_HEADER_ID
PO_LINE_ID
PO_LINE_LOCATION_ID
ITEM_ID
ITEM_REVISION
ITEM_DESCRIPTION
TRUCK_NUM
QUANTITY_SHIPPED
QUANTITY_RECEIVED
SHIP_TO_LOCATION_ID
PACKING_SLIP
PO_RELEASE_ID
CONTAINER_NUM
LINE_NUM
SHIPMENT_UNIT_PRICE
SECONDARY_QUANTITY_SHIPPED
SECONDARY_QUANTITY_RECEIVED
PO_SEGMENT1
PO_SHIPMENT_NUM
PO_SHIP_TO_LOCATION_ID
PO_LINE_NUMBER
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
LAST_UPDATE_LOGIN
CREATED_BY
ORGANIZATION_ID
UOM_CODE
SECONDARY_UOM_CODE
UNIT_OF_MEASURE
SECONDARY_UNIT_OF_MEASURE
REVISION_NUM
ASN_LPN_ID
SHIP_FROM_LOCATION_ID