VIEW: APPS.POFV_RFQ_SHIPMENTS

Source

View Text - Preformatted

SELECT qs.LINE_LOCATION_ID, qs.SHIPMENT_NUM, qs.PO_LINE_ID, ql.LINE_NUM, qs.PO_HEADER_ID, qu.SEGMENT1, qs.ORG_ID, op.NAME, qs.QUANTITY, qs.PRICE_OVERRIDE, qs.NEED_BY_DATE, qs.LAST_ACCEPT_DATE, '_LA:qs.FIRM_STATUS_LOOKUP_CODE:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', '_LA:DECODE(       NVL(qs.RECEIPT_REQUIRED_FLAG, ''N'') || NVL(qs.INSPECTION_REQUIRED_FLAG, ''N''),       ''NN'', ''2-Way'',        ''YN'', ''3-Way'',        ''YY'', ''4-Way'',        NULL):PO_LOOKUP_CODES:MATCHING TYPE:DISPLAYED_FIELD', qs.QTY_RCV_TOLERANCE, '_LA:qs.QTY_RCV_EXCEPTION_CODE:PO_LOOKUP_CODES:RECEIVING CONTROL LEVEL:DISPLAYED_FIELD', '_LA:qs.TAXABLE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', NULL, '_DF:PO:PO_LINE_LOCATIONS:qs', qs.UNIT_MEAS_LOOKUP_CODE, um.UOM_CLASS, um.DESCRIPTION, qs.TERMS_ID, pt.NAME, qs.CREATION_DATE, qs.CREATED_BY, qs.LAST_UPDATE_DATE, qs.LAST_UPDATED_BY, qs.VALUE_BASIS, qs.MATCHING_BASIS, qs.PAYMENT_TYPE, qs.DESCRIPTION, qs.WORK_APPROVER_ID, qs.BID_PAYMENT_ID, qs.QUANTITY_FINANCED, qs.AMOUNT_FINANCED, qs.QUANTITY_RECOUPED, qs.AMOUNT_RECOUPED, qs.RETAINAGE_WITHHELD_AMOUNT, qs.RETAINAGE_RELEASED_AMOUNT, qs.OUTSOURCED_ASSEMBLY, qs.TAX_ATTRIBUTE_UPDATE_CODE, qs.ORIGINAL_SHIPMENT_ID FROM PO_LINE_LOCATIONS_ALL QS, PO_LINES_ALL QL, PO_HEADERS_ALL QU, HR_ALL_ORGANIZATION_UNITS OP, AP_TERMS PT, MTL_UNITS_OF_MEASURE UM WHERE QU.TYPE_LOOKUP_CODE = 'RFQ' AND QU.QUOTATION_CLASS_CODE = 'BID' AND QS.SHIPMENT_TYPE = 'RFQ' AND QS.PO_LINE_ID = QL.PO_LINE_ID AND QS.PO_HEADER_ID = QU.PO_HEADER_ID AND QS.ORG_ID = OP.ORGANIZATION_ID AND QS.TERMS_ID = PT.TERM_ID(+) AND QS.UNIT_MEAS_LOOKUP_CODE = UM.UNIT_OF_MEASURE(+) WITH READ ONLY

View Text - HTML Formatted

SELECT QS.LINE_LOCATION_ID
, QS.SHIPMENT_NUM
, QS.PO_LINE_ID
, QL.LINE_NUM
, QS.PO_HEADER_ID
, QU.SEGMENT1
, QS.ORG_ID
, OP.NAME
, QS.QUANTITY
, QS.PRICE_OVERRIDE
, QS.NEED_BY_DATE
, QS.LAST_ACCEPT_DATE
, '_LA:QS.FIRM_STATUS_LOOKUP_CODE:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:DECODE( NVL(QS.RECEIPT_REQUIRED_FLAG
, ''N'') || NVL(QS.INSPECTION_REQUIRED_FLAG
, ''N'')
, ''NN''
, ''2-WAY''
, ''YN''
, ''3-WAY''
, ''YY''
, ''4-WAY''
, NULL):PO_LOOKUP_CODES:MATCHING TYPE:DISPLAYED_FIELD'
, QS.QTY_RCV_TOLERANCE
, '_LA:QS.QTY_RCV_EXCEPTION_CODE:PO_LOOKUP_CODES:RECEIVING CONTROL LEVEL:DISPLAYED_FIELD'
, '_LA:QS.TAXABLE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, NULL
, '_DF:PO:PO_LINE_LOCATIONS:QS'
, QS.UNIT_MEAS_LOOKUP_CODE
, UM.UOM_CLASS
, UM.DESCRIPTION
, QS.TERMS_ID
, PT.NAME
, QS.CREATION_DATE
, QS.CREATED_BY
, QS.LAST_UPDATE_DATE
, QS.LAST_UPDATED_BY
, QS.VALUE_BASIS
, QS.MATCHING_BASIS
, QS.PAYMENT_TYPE
, QS.DESCRIPTION
, QS.WORK_APPROVER_ID
, QS.BID_PAYMENT_ID
, QS.QUANTITY_FINANCED
, QS.AMOUNT_FINANCED
, QS.QUANTITY_RECOUPED
, QS.AMOUNT_RECOUPED
, QS.RETAINAGE_WITHHELD_AMOUNT
, QS.RETAINAGE_RELEASED_AMOUNT
, QS.OUTSOURCED_ASSEMBLY
, QS.TAX_ATTRIBUTE_UPDATE_CODE
, QS.ORIGINAL_SHIPMENT_ID
FROM PO_LINE_LOCATIONS_ALL QS
, PO_LINES_ALL QL
, PO_HEADERS_ALL QU
, HR_ALL_ORGANIZATION_UNITS OP
, AP_TERMS PT
, MTL_UNITS_OF_MEASURE UM
WHERE QU.TYPE_LOOKUP_CODE = 'RFQ'
AND QU.QUOTATION_CLASS_CODE = 'BID'
AND QS.SHIPMENT_TYPE = 'RFQ'
AND QS.PO_LINE_ID = QL.PO_LINE_ID
AND QS.PO_HEADER_ID = QU.PO_HEADER_ID
AND QS.ORG_ID = OP.ORGANIZATION_ID
AND QS.TERMS_ID = PT.TERM_ID(+)
AND QS.UNIT_MEAS_LOOKUP_CODE = UM.UNIT_OF_MEASURE(+) WITH READ ONLY