VIEW: APPS.RCV_FTE_LINES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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