VIEW: APPS.POFV_INBOUND_SHIPMENT_LINES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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