View: POFV_QUOTATION_PRICE_BREAKS

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.POFV_QUOTATION_PRICE_BREAKS

View Text

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

Columns