FND Design Data [Home] [Help]

View: POFV_SCHEDULED_SHIPMENTS

Product: PO - Purchasing
Description: - Retrofitted
Implementation/DBA Data: ViewAPPS.POFV_SCHEDULED_SHIPMENTS
View Text

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
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(+)
AND '_SEC:PS.ORG_ID' IS NOT NULL WITH READ ONLY

Columns

Name
PO_SHIPMENT_ID
SHIPMENT_NUMBER
PO_LINE_ID
LINE_NUMBER
PLANNED_PO_ID
PLANNED_PO_DOCUMENT_NUMBER
PLANNED_RELEASE_ID
RELEASE_NUMBER
OPERATING_UNIT_ID
OPERATING_UNIT_NAME
ACTUAL_PRICE
NEED_BY_DATE
PROMISED_DATE
LATEST_ACCEPTABLE_DATE
ORDERED_QUANTITY
SHIPPED_QUANTITY
RECEIVED_QUANTITY
CANCELLED_QUANTITY
ACCEPTED_QUANTITY
REJECTED_QUANTITY
BILLED_QUANTITY
"_LA:APPROVED_FLAG"
APPROVAL_DATE
"_LA:CANCEL_FLAG"
CANCEL_DATE
CANCEL_REASON
"_LA:CLOSURE_STATUS"
CLOSED_DATE
CLOSED_REASON
"_LA:FIRM_STATUS"
"_LA:ENCUMBERED_FLAG"
ENCUMBERED_DATE
"_LA:ACCRUE_ON_RECEIPT_FLAG"
"_LA:ALLOW_SUBSTITUTE_RECEIPT"
"_LA:ENFORCE_SHIP_TO_LOCATION"
"_LA:INVOICE_MATCHING"
QUANTITY_RECEIVED_TOLERANCE
"_LA:QTY_RECEIVED_EXCEPTION"
EARLY_RECEIPT_ALLOWED_DAYS
LATE_RECEIPT_ALLOWED_DAYS
"_LA:RECEIPT_DAYS_EXCEPTION"
RECEIVING_CLOSE_TOLERANCE
INVOICE_CLOSE_TOLERANCE
"_LA:TAXABLE_FLAG"
TAX_NAME
USSGL_TRANSACTION_CODE
"_DF"
UNIT_OF_MEASURE
UOM_CLASS
UOM_DESCRIPTION
SHIP_TO_ORGANIZATION_ID
SHIP_TO_ORGANIZATION_CODE
SHIP_TO_ORGANIZATION_NAME
SHIP_TO_LOCATION_ID
SHIP_TO_LOCATION
RECEIVING_ROUTING_ID
RECEIVING_ROUTING_NAME
CREATED_DATE
CREATED_BY
LAST_UPDATED_DATE
LAST_UPDATED_BY
SECONDARY_QUANTITY
SECONDARY_UNIT_OF_MEASURE
PREFERRED_GRADE
FINAL_MATCH_FLAG
SHIPMENT_CLOSED_DATE
CLOSED_FOR_RECEIVING_DATE
CLOSED_FOR_INVOICE_DATE