VIEW: APPS.POFV_QUOTATION_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.APPROVED_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', '_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', '_DF:PO:PO_LINE_LOCATIONS:qb', qb.UNIT_MEAS_LOOKUP_CODE, um.UOM_CLASS, um.DESCRIPTION, qb.TERMS_ID, pt.NAME, qb.SHIP_VIA_LOOKUP_CODE, fr.DESCRIPTION, fr.ORGANIZATION_ID, mp.ORGANIZATION_CODE, qb.FROM_HEADER_ID, fh.SEGMENT1, qb.FROM_LINE_ID, fl.LINE_NUM, qb.FROM_LINE_LOCATION_ID, fb.SHIPMENT_NUM, qb.LEAD_TIME_UNIT, lu.UOM_CLASS, lu.DESCRIPTION, 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.TAX_ATTRIBUTE_UPDATE_CODE, qb.OUTSOURCED_ASSEMBLY, qb.ORIGINAL_SHIPMENT_ID FROM PO_LINE_LOCATIONS_ALL QB, PO_LINES_ALL QL, PO_HEADERS_ALL QU, HR_ALL_ORGANIZATION_UNITS OP, AP_TERMS PT, ORG_FREIGHT FR, FINANCIALS_SYSTEM_PARAMS_ALL FP, MTL_PARAMETERS MP, PO_LINE_LOCATIONS_ALL FB, PO_LINES_ALL FL, PO_HEADERS_ALL FH, MTL_UNITS_OF_MEASURE UM, MTL_UNITS_OF_MEASURE LU WHERE QU.TYPE_LOOKUP_CODE = 'QUOTATION' AND QU.ORG_ID = FP.ORG_ID AND FP.INVENTORY_ORGANIZATION_ID = MP.ORGANIZATION_ID AND QU.QUOTATION_CLASS_CODE = 'CATALOG' AND QB.SHIPMENT_TYPE = 'QUOTATION' 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 AND QB.FROM_HEADER_ID = FH.PO_HEADER_ID(+) AND QB.FROM_LINE_ID = FL.PO_LINE_ID(+) AND QB.FROM_LINE_LOCATION_ID = FB.LINE_LOCATION_ID(+) AND QB.TERMS_ID = PT.TERM_ID(+) AND QB.SHIP_VIA_LOOKUP_CODE = FR.FREIGHT_CODE(+) AND NVL(FR.ORGANIZATION_ID, FP.INVENTORY_ORGANIZATION_ID) = FP.INVENTORY_ORGANIZATION_ID AND QB.UNIT_MEAS_LOOKUP_CODE = UM.UNIT_OF_MEASURE(+) AND QB.LEAD_TIME_UNIT = LU.UNIT_OF_MEASURE(+) 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.APPROVED_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_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'
, '_DF:PO:PO_LINE_LOCATIONS:QB'
, QB.UNIT_MEAS_LOOKUP_CODE
, UM.UOM_CLASS
, UM.DESCRIPTION
, QB.TERMS_ID
, PT.NAME
, QB.SHIP_VIA_LOOKUP_CODE
, FR.DESCRIPTION
, FR.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, QB.FROM_HEADER_ID
, FH.SEGMENT1
, QB.FROM_LINE_ID
, FL.LINE_NUM
, QB.FROM_LINE_LOCATION_ID
, FB.SHIPMENT_NUM
, QB.LEAD_TIME_UNIT
, LU.UOM_CLASS
, LU.DESCRIPTION
, 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.TAX_ATTRIBUTE_UPDATE_CODE
, QB.OUTSOURCED_ASSEMBLY
, QB.ORIGINAL_SHIPMENT_ID
FROM PO_LINE_LOCATIONS_ALL QB
, PO_LINES_ALL QL
, PO_HEADERS_ALL QU
, HR_ALL_ORGANIZATION_UNITS OP
, AP_TERMS PT
, ORG_FREIGHT FR
, FINANCIALS_SYSTEM_PARAMS_ALL FP
, MTL_PARAMETERS MP
, PO_LINE_LOCATIONS_ALL FB
, PO_LINES_ALL FL
, PO_HEADERS_ALL FH
, MTL_UNITS_OF_MEASURE UM
, MTL_UNITS_OF_MEASURE LU
WHERE QU.TYPE_LOOKUP_CODE = 'QUOTATION'
AND QU.ORG_ID = FP.ORG_ID
AND FP.INVENTORY_ORGANIZATION_ID = MP.ORGANIZATION_ID
AND QU.QUOTATION_CLASS_CODE = 'CATALOG'
AND QB.SHIPMENT_TYPE = 'QUOTATION'
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
AND QB.FROM_HEADER_ID = FH.PO_HEADER_ID(+)
AND QB.FROM_LINE_ID = FL.PO_LINE_ID(+)
AND QB.FROM_LINE_LOCATION_ID = FB.LINE_LOCATION_ID(+)
AND QB.TERMS_ID = PT.TERM_ID(+)
AND QB.SHIP_VIA_LOOKUP_CODE = FR.FREIGHT_CODE(+)
AND NVL(FR.ORGANIZATION_ID
, FP.INVENTORY_ORGANIZATION_ID) = FP.INVENTORY_ORGANIZATION_ID
AND QB.UNIT_MEAS_LOOKUP_CODE = UM.UNIT_OF_MEASURE(+)
AND QB.LEAD_TIME_UNIT = LU.UNIT_OF_MEASURE(+) WITH READ ONLY