View: POFV_INBOUND_SHIPMENT_LINES

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

View Text

SELECT SL.SHIPMENT_LINE_ID
, SL.LINE_NUM
, SL.QUANTITY_RECEIVED
, SL.QUANTITY_SHIPPED
, SL.NOTICE_UNIT_PRICE
, SL.SHIPMENT_UNIT_PRICE
, SL.ITEM_DESCRIPTION
, SL.COMMENTS
, SL.SHIPMENT_LINE_STATUS_CODE
, '_LA:SL.ASN_LINE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, SL.BAR_CODE_LABEL
, SL.CONTAINER_NUM
, '_LA:SL.DESTINATION_TYPE_CODE:PO_LOOKUP_CODES:DESTINATION TYPE:DISPLAYED_FIELD'
, SL.PACKING_SLIP
, '_LA:SL.SOURCE_DOCUMENT_CODE:PO_LOOKUP_CODES:SHIPMENT SOURCE DOCUMENT TYPE:DISPLAYED_FIELD'
, SL.VENDOR_ITEM_NUM
, SL.VENDOR_LOT_NUM
, SL.VENDOR_CUM_SHIPPED_QUANTITY
, SL.TRANSFER_COST
, SL.TRANSFER_PERCENTAGE
, SL.TRUCK_NUM
, RE.REASON_NAME
, SL.USSGL_TRANSACTION_CODE
, '_DF:PO:RCV_SHIPMENT_LINES:SL'
, SL.SHIPMENT_HEADER_ID
, SH.VENDOR_ID
, VE.VENDOR_NAME
, SL.ITEM_ID
, '_KF:INV:MSTK:SI'
, SL.ITEM_REVISION
, SL.CATEGORY_ID
, '_KF:INV:MCAT:CT'
, PH.ORG_ID
, OP.NAME
, SL.PO_HEADER_ID
, PH.SEGMENT1
, '_LA:PH.TYPE_LOOKUP_CODE:PO_LOOKUP_CODES:DOCUMENT SUBTYPE:DISPLAYED_FIELD'
, SL.PO_RELEASE_ID
, PR.RELEASE_NUM
, SL.PO_LINE_ID
, PL.LINE_NUM
, SL.PO_LINE_LOCATION_ID
, PS.SHIPMENT_NUM
, '_LA:PS.SHIPMENT_TYPE:PO_LOOKUP_CODES:SHIPMENT TYPE:DISPLAYED_FIELD'
, SL.PO_DISTRIBUTION_ID
, PD.DISTRIBUTION_NUM
, SL.REQUISITION_LINE_ID
, RH.SEGMENT1
, RL.LINE_NUM
, SL.REQ_DISTRIBUTION_ID
, RD.DISTRIBUTION_NUM
, SL.ROUTING_HEADER_ID
, RR.ROUTING_NAME
, SL.FROM_ORGANIZATION_ID
, FC.ORGANIZATION_CODE
, FN.NAME
, SL.TO_ORGANIZATION_ID
, TC.ORGANIZATION_CODE
, TN.NAME
, SL.TO_SUBINVENTORY
, SL.DELIVER_TO_LOCATION_ID
, DO.LOCATION_CODE
, SL.DELIVER_TO_PERSON_ID
, DP.FULL_NAME
, SL.SHIP_TO_LOCATION_ID
, SO.LOCATION_CODE
, SL.CHARGE_ACCOUNT_ID
, '_KF:SQLGL:GL#:CC'
, SL.TRANSPORTATION_ACCOUNT_ID
, '_KF:SQLGL:GL#:RC'
, SL.UNIT_OF_MEASURE
, UM.UOM_CLASS
, UM.DESCRIPTION
, SL.PRIMARY_UNIT_OF_MEASURE
, PU.UOM_CLASS
, PU.DESCRIPTION
, SL.CREATION_DATE
, SL.CREATED_BY
, SL.LAST_UPDATE_DATE
, SL.LAST_UPDATED_BY
, SL.SECONDARY_QUANTITY_SHIPPED
, SL.SECONDARY_QUANTITY_RECEIVED
, SL.SECONDARY_UNIT_OF_MEASURE
, SL.QC_GRADE
, PS.DROP_SHIP_FLAG
, PS.SALES_ORDER_UPDATE_DATE
FROM RCV_SHIPMENT_LINES SL
, RCV_SHIPMENT_HEADERS SH
, PO_VENDORS VE
, MTL_CATEGORIES CT
, MTL_SYSTEM_ITEMS SI
, MTL_ITEM_REVISIONS IR
, HR_ALL_ORGANIZATION_UNITS OP
, PO_HEADERS_ALL PH
, PO_RELEASES_ALL PR
, PO_LINES_ALL PL
, PO_LINE_LOCATIONS_ALL PS
, PO_DISTRIBUTIONS_ALL PD
, PO_REQUISITION_HEADERS_ALL RH
, PO_REQUISITION_LINES_ALL RL
, PO_REQ_DISTRIBUTIONS_ALL RD
, RCV_ROUTING_HEADERS RR
, MTL_PARAMETERS FC
, HR_ALL_ORGANIZATION_UNITS FN
, MTL_PARAMETERS TC
, HR_ALL_ORGANIZATION_UNITS TN
, MTL_SECONDARY_INVENTORIES SU
, HR_LOCATIONS DO
, PER_PEOPLE_F DP
, HR_LOCATIONS SO
, GL_CODE_COMBINATIONS CC
, GL_CODE_COMBINATIONS RC
, MTL_UNITS_OF_MEASURE UM
, MTL_UNITS_OF_MEASURE PU
, MTL_TRANSACTION_REASONS RE
WHERE SL.SHIPMENT_HEADER_ID = SH.SHIPMENT_HEADER_ID(+)
AND SH.VENDOR_ID = VE.VENDOR_ID(+)
AND SL.CATEGORY_ID = CT.CATEGORY_ID(+)
AND SL.ITEM_ID = SI.INVENTORY_ITEM_ID(+)
AND SL.FROM_ORGANIZATION_ID = SI.ORGANIZATION_ID(+)
AND SL.ITEM_REVISION = IR.REVISION(+)
AND SL.ITEM_ID = IR.INVENTORY_ITEM_ID(+)
AND SL.FROM_ORGANIZATION_ID = IR.ORGANIZATION_ID(+)
AND SL.PO_HEADER_ID = PH.PO_HEADER_ID(+)
AND PH.ORG_ID = OP.ORGANIZATION_ID(+)
AND SL.PO_RELEASE_ID = PR.PO_RELEASE_ID(+)
AND SL.PO_LINE_ID = PL.PO_LINE_ID(+)
AND SL.PO_LINE_LOCATION_ID = PS.LINE_LOCATION_ID(+)
AND SL.PO_DISTRIBUTION_ID = PD.PO_DISTRIBUTION_ID(+)
AND SL.REQUISITION_LINE_ID = RL.REQUISITION_LINE_ID(+)
AND RL.REQUISITION_HEADER_ID = RH.REQUISITION_HEADER_ID(+)
AND SL.REQ_DISTRIBUTION_ID = RD.DISTRIBUTION_ID(+)
AND SL.ROUTING_HEADER_ID = RR.ROUTING_HEADER_ID(+)
AND SL.FROM_ORGANIZATION_ID = FC.ORGANIZATION_ID(+)
AND SL.FROM_ORGANIZATION_ID = FN.ORGANIZATION_ID(+)
AND SL.TO_ORGANIZATION_ID = TC.ORGANIZATION_ID(+)
AND SL.TO_ORGANIZATION_ID = TN.ORGANIZATION_ID(+)
AND SL.TO_SUBINVENTORY = SU.SECONDARY_INVENTORY_NAME(+)
AND SL.TO_ORGANIZATION_ID = SU.ORGANIZATION_ID(+)
AND SL.DELIVER_TO_LOCATION_ID = DO.LOCATION_ID(+)
AND SL.DELIVER_TO_PERSON_ID = DP.PERSON_ID(+)
AND SL.SHIP_TO_LOCATION_ID = SO.LOCATION_ID(+)
AND DP.EFFECTIVE_START_DATE(+) <= TRUNC(SYSDATE)
AND DP.EFFECTIVE_END_DATE(+) >= TRUNC(SYSDATE)
AND SL.CHARGE_ACCOUNT_ID = CC.CODE_COMBINATION_ID(+)
AND SL.TRANSPORTATION_ACCOUNT_ID = RC.CODE_COMBINATION_ID(+)
AND SL.UNIT_OF_MEASURE = UM.UNIT_OF_MEASURE(+)
AND SL.PRIMARY_UNIT_OF_MEASURE = PU.UNIT_OF_MEASURE(+)
AND SL.REASON_ID = RE.REASON_ID(+) WITH READ ONLY

Columns