VIEW: APPS.POFV_SCHEDULED_SHIPMENTS

Source

View Text - Preformatted

SELECT PS.LINE_LOCATION_ID, PS.SHIPMENT_NUM, PS.PO_LINE_ID, PL.LINE_NUM, PS.PO_HEADER_ID, PH.SEGMENT1, PS.PO_RELEASE_ID, PR.RELEASE_NUM, PS.ORG_ID, OP.NAME, PS.PRICE_OVERRIDE, PS.NEED_BY_DATE, PS.PROMISED_DATE, PS.LAST_ACCEPT_DATE, PS.QUANTITY, PS.QUANTITY_SHIPPED, PS.QUANTITY_RECEIVED, PS.QUANTITY_CANCELLED, PS.QUANTITY_ACCEPTED, PS.QUANTITY_REJECTED, PS.QUANTITY_BILLED, '_LA:ps.APPROVED_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', PS.APPROVED_DATE, '_LA:ps.CANCEL_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', PS.CANCEL_DATE, PS.CANCEL_REASON, '_LA:ps.CLOSED_CODE:PO_LOOKUP_CODES:DOCUMENT STATE:DISPLAYED_FIELD', PS.CLOSED_DATE, PS.CLOSED_REASON, '_LA:ps.FIRM_STATUS_LOOKUP_CODE:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', '_LA:ps.ENCUMBERED_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', PS.ENCUMBERED_DATE, '_LA:ps.ACCRUE_ON_RECEIPT_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', '_LA:ps.ALLOW_SUBSTITUTE_RECEIPTS_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', '_LA:ps.ENFORCE_SHIP_TO_LOCATION_CODE:PO_LOOKUP_CODES:RECEIVING CONTROL LEVEL:DISPLAYED_FIELD', '_LA:DECODE( NVL(ps.RECEIPT_REQUIRED_FLAG, ''N'') || NVL(ps.INSPECTION_REQUIRED_FLAG, ''N''), ''NN'', ''2-Way'', ''YN'', ''3-Way'', ''YY'', ''4-Way'', NULL):PO_LOOKUP_CODES:MATCHING TYPE:DISPLAYED_FIELD', PS.QTY_RCV_TOLERANCE, '_LA:ps.QTY_RCV_EXCEPTION_CODE:PO_LOOKUP_CODES:RECEIVING CONTROL LEVEL:DISPLAYED_FIELD', PS.DAYS_EARLY_RECEIPT_ALLOWED, PS.DAYS_LATE_RECEIPT_ALLOWED, '_LA:ps.RECEIPT_DAYS_EXCEPTION_CODE:PO_LOOKUP_CODES:RECEIVING CONTROL LEVEL:DISPLAYED_FIELD', PS.RECEIVE_CLOSE_TOLERANCE, PS.INVOICE_CLOSE_TOLERANCE, '_LA:ps.TAXABLE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', PS.TAX_NAME, PS.USSGL_TRANSACTION_CODE, '_DF:PO:PO_LINE_LOCATIONS:ps', PS.UNIT_MEAS_LOOKUP_CODE, UM.UOM_CLASS, UM.DESCRIPTION, PS.SHIP_TO_ORGANIZATION_ID, OC.ORGANIZATION_CODE, OG.NAME, PS.SHIP_TO_LOCATION_ID, LO.LOCATION_CODE, PS.RECEIVING_ROUTING_ID, RU.ROUTING_NAME, PS.CREATION_DATE, PS.CREATED_BY, PS.LAST_UPDATE_DATE, PS.LAST_UPDATED_BY, PL.SECONDARY_QUANTITY, PL.SECONDARY_UNIT_OF_MEASURE, PL.PREFERRED_GRADE, PS.FINAL_MATCH_FLAG, PS.SHIPMENT_CLOSED_DATE, PS.CLOSED_FOR_RECEIVING_DATE, PS.CLOSED_FOR_INVOICE_DATE , PS.VALUE_BASIS, PS.MATCHING_BASIS, PS.PAYMENT_TYPE, PS.DESCRIPTION, PS.WORK_APPROVER_ID, PS.BID_PAYMENT_ID, PS.QUANTITY_FINANCED, PS.AMOUNT_FINANCED, PS.QUANTITY_RECOUPED, PS.AMOUNT_RECOUPED, PS.RETAINAGE_WITHHELD_AMOUNT, PS.RETAINAGE_RELEASED_AMOUNT, PS.OUTSOURCED_ASSEMBLY, PS.TAX_ATTRIBUTE_UPDATE_CODE, PS.ORIGINAL_SHIPMENT_ID FROM PO_LINE_LOCATIONS_ALL PS, PO_LINES_ALL PL, PO_HEADERS_ALL PH, PO_RELEASES_ALL PR, HR_ALL_ORGANIZATION_UNITS OP, RCV_ROUTING_HEADERS RU, HR_LOCATIONS LO, HR_ALL_ORGANIZATION_UNITS OG, MTL_PARAMETERS OC, PO_LINE_LOCATIONS_ALL SR, PO_LINES_ALL SL, MTL_UNITS_OF_MEASURE UM WHERE PH.TYPE_LOOKUP_CODE = 'PLANNED' AND PS.SHIPMENT_TYPE = 'SCHEDULED' AND PS.PO_LINE_ID = PL.PO_LINE_ID AND PS.PO_HEADER_ID = PH.PO_HEADER_ID AND PS.PO_RELEASE_ID = PR.PO_RELEASE_ID AND PS.ORG_ID = OP.ORGANIZATION_ID AND PS.RECEIVING_ROUTING_ID = RU.ROUTING_HEADER_ID(+) AND PS.SHIP_TO_LOCATION_ID = LO.LOCATION_ID(+) AND PS.SHIP_TO_ORGANIZATION_ID = OG.ORGANIZATION_ID(+) AND PS.SHIP_TO_ORGANIZATION_ID = OC.ORGANIZATION_ID(+) AND PS.SOURCE_SHIPMENT_ID = SR.LINE_LOCATION_ID AND SR.PO_LINE_ID = SL.PO_LINE_ID AND PS.UNIT_MEAS_LOOKUP_CODE = UM.UNIT_OF_MEASURE(+) WITH READ ONLY

View Text - HTML Formatted

SELECT PS.LINE_LOCATION_ID
, PS.SHIPMENT_NUM
, PS.PO_LINE_ID
, PL.LINE_NUM
, PS.PO_HEADER_ID
, PH.SEGMENT1
, PS.PO_RELEASE_ID
, PR.RELEASE_NUM
, PS.ORG_ID
, OP.NAME
, PS.PRICE_OVERRIDE
, PS.NEED_BY_DATE
, PS.PROMISED_DATE
, PS.LAST_ACCEPT_DATE
, PS.QUANTITY
, PS.QUANTITY_SHIPPED
, PS.QUANTITY_RECEIVED
, PS.QUANTITY_CANCELLED
, PS.QUANTITY_ACCEPTED
, PS.QUANTITY_REJECTED
, PS.QUANTITY_BILLED
, '_LA:PS.APPROVED_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, PS.APPROVED_DATE
, '_LA:PS.CANCEL_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, PS.CANCEL_DATE
, PS.CANCEL_REASON
, '_LA:PS.CLOSED_CODE:PO_LOOKUP_CODES:DOCUMENT STATE:DISPLAYED_FIELD'
, PS.CLOSED_DATE
, PS.CLOSED_REASON
, '_LA:PS.FIRM_STATUS_LOOKUP_CODE:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:PS.ENCUMBERED_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, PS.ENCUMBERED_DATE
, '_LA:PS.ACCRUE_ON_RECEIPT_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:PS.ALLOW_SUBSTITUTE_RECEIPTS_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:PS.ENFORCE_SHIP_TO_LOCATION_CODE:PO_LOOKUP_CODES:RECEIVING CONTROL LEVEL:DISPLAYED_FIELD'
, '_LA:DECODE( NVL(PS.RECEIPT_REQUIRED_FLAG
, ''N'') || NVL(PS.INSPECTION_REQUIRED_FLAG
, ''N'')
, ''NN''
, ''2-WAY''
, ''YN''
, ''3-WAY''
, ''YY''
, ''4-WAY''
, NULL):PO_LOOKUP_CODES:MATCHING TYPE:DISPLAYED_FIELD'
, PS.QTY_RCV_TOLERANCE
, '_LA:PS.QTY_RCV_EXCEPTION_CODE:PO_LOOKUP_CODES:RECEIVING CONTROL LEVEL:DISPLAYED_FIELD'
, PS.DAYS_EARLY_RECEIPT_ALLOWED
, PS.DAYS_LATE_RECEIPT_ALLOWED
, '_LA:PS.RECEIPT_DAYS_EXCEPTION_CODE:PO_LOOKUP_CODES:RECEIVING CONTROL LEVEL:DISPLAYED_FIELD'
, PS.RECEIVE_CLOSE_TOLERANCE
, PS.INVOICE_CLOSE_TOLERANCE
, '_LA:PS.TAXABLE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, PS.TAX_NAME
, PS.USSGL_TRANSACTION_CODE
, '_DF:PO:PO_LINE_LOCATIONS:PS'
, PS.UNIT_MEAS_LOOKUP_CODE
, UM.UOM_CLASS
, UM.DESCRIPTION
, PS.SHIP_TO_ORGANIZATION_ID
, OC.ORGANIZATION_CODE
, OG.NAME
, PS.SHIP_TO_LOCATION_ID
, LO.LOCATION_CODE
, PS.RECEIVING_ROUTING_ID
, RU.ROUTING_NAME
, PS.CREATION_DATE
, PS.CREATED_BY
, PS.LAST_UPDATE_DATE
, PS.LAST_UPDATED_BY
, PL.SECONDARY_QUANTITY
, PL.SECONDARY_UNIT_OF_MEASURE
, PL.PREFERRED_GRADE
, PS.FINAL_MATCH_FLAG
, PS.SHIPMENT_CLOSED_DATE
, PS.CLOSED_FOR_RECEIVING_DATE
, PS.CLOSED_FOR_INVOICE_DATE
, PS.VALUE_BASIS
, PS.MATCHING_BASIS
, PS.PAYMENT_TYPE
, PS.DESCRIPTION
, PS.WORK_APPROVER_ID
, PS.BID_PAYMENT_ID
, PS.QUANTITY_FINANCED
, PS.AMOUNT_FINANCED
, PS.QUANTITY_RECOUPED
, PS.AMOUNT_RECOUPED
, PS.RETAINAGE_WITHHELD_AMOUNT
, PS.RETAINAGE_RELEASED_AMOUNT
, PS.OUTSOURCED_ASSEMBLY
, PS.TAX_ATTRIBUTE_UPDATE_CODE
, PS.ORIGINAL_SHIPMENT_ID
FROM PO_LINE_LOCATIONS_ALL PS
, PO_LINES_ALL PL
, PO_HEADERS_ALL PH
, PO_RELEASES_ALL PR
, HR_ALL_ORGANIZATION_UNITS OP
, RCV_ROUTING_HEADERS RU
, HR_LOCATIONS LO
, HR_ALL_ORGANIZATION_UNITS OG
, MTL_PARAMETERS OC
, PO_LINE_LOCATIONS_ALL SR
, PO_LINES_ALL SL
, MTL_UNITS_OF_MEASURE UM
WHERE PH.TYPE_LOOKUP_CODE = 'PLANNED'
AND PS.SHIPMENT_TYPE = 'SCHEDULED'
AND PS.PO_LINE_ID = PL.PO_LINE_ID
AND PS.PO_HEADER_ID = PH.PO_HEADER_ID
AND PS.PO_RELEASE_ID = PR.PO_RELEASE_ID
AND PS.ORG_ID = OP.ORGANIZATION_ID
AND PS.RECEIVING_ROUTING_ID = RU.ROUTING_HEADER_ID(+)
AND PS.SHIP_TO_LOCATION_ID = LO.LOCATION_ID(+)
AND PS.SHIP_TO_ORGANIZATION_ID = OG.ORGANIZATION_ID(+)
AND PS.SHIP_TO_ORGANIZATION_ID = OC.ORGANIZATION_ID(+)
AND PS.SOURCE_SHIPMENT_ID = SR.LINE_LOCATION_ID
AND SR.PO_LINE_ID = SL.PO_LINE_ID
AND PS.UNIT_MEAS_LOOKUP_CODE = UM.UNIT_OF_MEASURE(+) WITH READ ONLY