View: POFV_QUOTATION_SHIPMENTS

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

View Text

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.APPROVED_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_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'
, TAX.NAME
, '_DF:PO:PO_LINE_LOCATIONS:QS'
, QS.UNIT_MEAS_LOOKUP_CODE
, UM.UOM_CLASS
, UM.DESCRIPTION
, QS.TERMS_ID
, PT.NAME
, QS.FROM_HEADER_ID
, FH.SEGMENT1
, QS.FROM_LINE_ID
, FL.LINE_NUM
, QS.FROM_LINE_LOCATION_ID
, FB.SHIPMENT_NUM
, QS.CREATION_DATE
, QS.CREATED_BY
, QS.LAST_UPDATE_DATE
, QS.LAST_UPDATED_BY
FROM PO_LINE_LOCATIONS_ALL QS
, PO_LINES_ALL QL
, PO_HEADERS_ALL QU
, HR_ALL_ORGANIZATION_UNITS OP
, AP_TERMS PT
, PO_LINE_LOCATIONS_ALL FB
, PO_LINES_ALL FL
, PO_HEADERS_ALL FH
, AP_TAX_CODES_ALL TAX
, MTL_UNITS_OF_MEASURE UM
WHERE QU.TYPE_LOOKUP_CODE = 'QUOTATION'
AND QU.QUOTATION_CLASS_CODE = 'BID'
AND QS.SHIPMENT_TYPE = 'QUOTATION'
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.FROM_HEADER_ID = FH.PO_HEADER_ID(+)
AND QS.FROM_LINE_ID = FL.PO_LINE_ID(+)
AND QS.FROM_LINE_LOCATION_ID = FB.LINE_LOCATION_ID(+)
AND QS.TERMS_ID = PT.TERM_ID(+)
AND QS.UNIT_MEAS_LOOKUP_CODE = UM.UNIT_OF_MEASURE(+)
AND QS.TAX_CODE_ID = TAX.TAX_ID(+)
AND '_SEC:QS.ORG_ID' IS NOT NULL WITH READ ONLY

Columns