VIEW: APPS.POFV_STD_PO_LINE_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.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', NULL, 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, PS.SECONDARY_QUANTITY, PS.SECONDARY_UNIT_OF_MEASURE, PS.PREFERRED_GRADE, PS.RETROACTIVE_DATE, PS.DROP_SHIP_FLAG, PS.SALES_ORDER_UPDATE_DATE, '_LA:ps.VMI_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', '_LA:ps.CONSIGNED_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', PS.AMOUNT, PS.AMOUNT_CANCELLED, PS.AMOUNT_RECEIVED, PS.AMOUNT_BILLED, PS.AMOUNT_ACCEPTED, PS.AMOUNT_REJECTED, PS.FINAL_MATCH_FLAG, PS.SHIPMENT_CLOSED_DATE, PS.CLOSED_FOR_RECEIVING_DATE, PS.CLOSED_FOR_INVOICE_DATE FROM PO_LINE_LOCATIONS_ALL PS, PO_LINES_ALL PL, PO_HEADERS_ALL PH, HR_ALL_ORGANIZATION_UNITS OP, RCV_ROUTING_HEADERS RU, HR_LOCATIONS LO, HR_ALL_ORGANIZATION_UNITS OG, MTL_PARAMETERS OC, MTL_UNITS_OF_MEASURE UM WHERE PH.TYPE_LOOKUP_CODE = 'STANDARD' AND PS.SHIPMENT_TYPE = 'STANDARD' AND PS.PO_LINE_ID = PL.PO_LINE_ID AND PS.PO_HEADER_ID = PH.PO_HEADER_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.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.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'
, NULL
, 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
, PS.SECONDARY_QUANTITY
, PS.SECONDARY_UNIT_OF_MEASURE
, PS.PREFERRED_GRADE
, PS.RETROACTIVE_DATE
, PS.DROP_SHIP_FLAG
, PS.SALES_ORDER_UPDATE_DATE
, '_LA:PS.VMI_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:PS.CONSIGNED_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, PS.AMOUNT
, PS.AMOUNT_CANCELLED
, PS.AMOUNT_RECEIVED
, PS.AMOUNT_BILLED
, PS.AMOUNT_ACCEPTED
, PS.AMOUNT_REJECTED
, PS.FINAL_MATCH_FLAG
, PS.SHIPMENT_CLOSED_DATE
, PS.CLOSED_FOR_RECEIVING_DATE
, PS.CLOSED_FOR_INVOICE_DATE
FROM PO_LINE_LOCATIONS_ALL PS
, PO_LINES_ALL PL
, PO_HEADERS_ALL PH
, HR_ALL_ORGANIZATION_UNITS OP
, RCV_ROUTING_HEADERS RU
, HR_LOCATIONS LO
, HR_ALL_ORGANIZATION_UNITS OG
, MTL_PARAMETERS OC
, MTL_UNITS_OF_MEASURE UM
WHERE PH.TYPE_LOOKUP_CODE = 'STANDARD'
AND PS.SHIPMENT_TYPE = 'STANDARD'
AND PS.PO_LINE_ID = PL.PO_LINE_ID
AND PS.PO_HEADER_ID = PH.PO_HEADER_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.UNIT_MEAS_LOOKUP_CODE = UM.UNIT_OF_MEASURE(+) WITH READ ONLY