VIEW: APPS.POBV_RFQ_PRICE_BREAKS

Source

View Text - Preformatted

SELECT qb.LINE_LOCATION_ID, qb.SHIPMENT_NUM, qb.PO_LINE_ID, ql.LINE_NUM, qb.PO_HEADER_ID, qu.SEGMENT1, qb.ORG_ID, op.NAME, qb.QUANTITY, qb.PRICE_OVERRIDE, qb.PRICE_DISCOUNT, qb.START_DATE, qb.END_DATE, '_LA:qb.FREIGHT_TERMS_LOOKUP_CODE:PO_LOOKUP_CODES:FREIGHT TERMS:DISPLAYED_FIELD', '_LA:qb.FOB_LOOKUP_CODE:AR_LOOKUPS:FOB:MEANING', '_LA:DECODE(       NVL(qb.RECEIPT_REQUIRED_FLAG, ''N'') || NVL(qb.INSPECTION_REQUIRED_FLAG, ''N''),       ''NN'', ''2-Way'',        ''YN'', ''3-Way'',        ''YY'', ''4-Way'',        NULL):PO_LOOKUP_CODES:MATCHING TYPE:DISPLAYED_FIELD', qb.QTY_RCV_TOLERANCE, '_LA:qb.QTY_RCV_EXCEPTION_CODE:PO_LOOKUP_CODES:RECEIVING CONTROL LEVEL:DISPLAYED_FIELD', qb.LEAD_TIME, '_LA:qb.TAXABLE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', qb.UNIT_MEAS_LOOKUP_CODE, qb.TERMS_ID, qb.SHIP_VIA_LOOKUP_CODE, qb.LEAD_TIME_UNIT, qb.CREATION_DATE, qb.CREATED_BY, qb.LAST_UPDATE_DATE, qb.LAST_UPDATED_BY, qb.VALUE_BASIS, qb.MATCHING_BASIS, qb.PAYMENT_TYPE, qb.DESCRIPTION, qb.WORK_APPROVER_ID, qb.BID_PAYMENT_ID, qb.QUANTITY_FINANCED, qb.AMOUNT_FINANCED, qb.QUANTITY_RECOUPED, qb.AMOUNT_RECOUPED, qb.RETAINAGE_WITHHELD_AMOUNT, qb.RETAINAGE_RELEASED_AMOUNT, qb.OUTSOURCED_ASSEMBLY, qb.TAX_ATTRIBUTE_UPDATE_CODE, qb.ORIGINAL_SHIPMENT_ID FROM PO_LINE_LOCATIONS_ALL QB, PO_LINES_ALL QL, PO_HEADERS_ALL QU, HR_ALL_ORGANIZATION_UNITS OP WHERE QU.TYPE_LOOKUP_CODE = 'RFQ' AND QU.QUOTATION_CLASS_CODE = 'CATALOG' AND QB.SHIPMENT_TYPE = 'RFQ' AND QB.PO_LINE_ID = QL.PO_LINE_ID AND QB.PO_HEADER_ID = QU.PO_HEADER_ID AND QB.ORG_ID = OP.ORGANIZATION_ID WITH READ ONLY

View Text - HTML Formatted

SELECT QB.LINE_LOCATION_ID
, QB.SHIPMENT_NUM
, QB.PO_LINE_ID
, QL.LINE_NUM
, QB.PO_HEADER_ID
, QU.SEGMENT1
, QB.ORG_ID
, OP.NAME
, QB.QUANTITY
, QB.PRICE_OVERRIDE
, QB.PRICE_DISCOUNT
, QB.START_DATE
, QB.END_DATE
, '_LA:QB.FREIGHT_TERMS_LOOKUP_CODE:PO_LOOKUP_CODES:FREIGHT TERMS:DISPLAYED_FIELD'
, '_LA:QB.FOB_LOOKUP_CODE:AR_LOOKUPS:FOB:MEANING'
, '_LA:DECODE( NVL(QB.RECEIPT_REQUIRED_FLAG
, ''N'') || NVL(QB.INSPECTION_REQUIRED_FLAG
, ''N'')
, ''NN''
, ''2-WAY''
, ''YN''
, ''3-WAY''
, ''YY''
, ''4-WAY''
, NULL):PO_LOOKUP_CODES:MATCHING TYPE:DISPLAYED_FIELD'
, QB.QTY_RCV_TOLERANCE
, '_LA:QB.QTY_RCV_EXCEPTION_CODE:PO_LOOKUP_CODES:RECEIVING CONTROL LEVEL:DISPLAYED_FIELD'
, QB.LEAD_TIME
, '_LA:QB.TAXABLE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, QB.UNIT_MEAS_LOOKUP_CODE
, QB.TERMS_ID
, QB.SHIP_VIA_LOOKUP_CODE
, QB.LEAD_TIME_UNIT
, QB.CREATION_DATE
, QB.CREATED_BY
, QB.LAST_UPDATE_DATE
, QB.LAST_UPDATED_BY
, QB.VALUE_BASIS
, QB.MATCHING_BASIS
, QB.PAYMENT_TYPE
, QB.DESCRIPTION
, QB.WORK_APPROVER_ID
, QB.BID_PAYMENT_ID
, QB.QUANTITY_FINANCED
, QB.AMOUNT_FINANCED
, QB.QUANTITY_RECOUPED
, QB.AMOUNT_RECOUPED
, QB.RETAINAGE_WITHHELD_AMOUNT
, QB.RETAINAGE_RELEASED_AMOUNT
, QB.OUTSOURCED_ASSEMBLY
, QB.TAX_ATTRIBUTE_UPDATE_CODE
, QB.ORIGINAL_SHIPMENT_ID
FROM PO_LINE_LOCATIONS_ALL QB
, PO_LINES_ALL QL
, PO_HEADERS_ALL QU
, HR_ALL_ORGANIZATION_UNITS OP
WHERE QU.TYPE_LOOKUP_CODE = 'RFQ'
AND QU.QUOTATION_CLASS_CODE = 'CATALOG'
AND QB.SHIPMENT_TYPE = 'RFQ'
AND QB.PO_LINE_ID = QL.PO_LINE_ID
AND QB.PO_HEADER_ID = QU.PO_HEADER_ID
AND QB.ORG_ID = OP.ORGANIZATION_ID WITH READ ONLY