[Home] [Help]
View: PJM_PROJECT_QUOT_V
Product: | PJM - Project Manufacturing |
Description: | Project related quotation information for the Web Inquiry. |
Implementation/DBA Data: |
APPS.PJM_PROJECT_QUOT_V
|
View Text
SELECT DISTINCT LINE.PROJECT_ID
, LINE.TASK_ID
, POH.PO_HEADER_ID
, POH.SEGMENT1
, POLC1.DISPLAYED_FIELD
, POLC2.DISPLAYED_FIELD
, POLC.DISPLAYED_FIELD
, POH1.PO_HEADER_ID
, POH1.SEGMENT1
, POH.START_DATE
, POH.END_DATE
, POH.VENDOR_ID
, POV.VENDOR_NAME
, POH.AGENT_ID
, PO_INQ_SV.GET_PERSON_NAME(POH.AGENT_ID)
FROM PO_LOOKUP_CODES POLC
, PO_LOOKUP_CODES POLC1
, PO_LOOKUP_CODES POLC2
, PO_VENDORS POV
, PO_HEADERS POH
, PO_HEADERS POH1
, PO_LINES LINE
WHERE POLC.LOOKUP_CODE (+) = NVL(POH.STATUS_LOOKUP_CODE
, 'I')
AND POLC.LOOKUP_TYPE = 'RFQ/QUOTE STATUS'
AND POLC1.LOOKUP_CODE (+) = NVL(POH.QUOTE_TYPE_LOOKUP_CODE
, 'STANDARD')
AND POLC1.LOOKUP_TYPE = 'QUOTATION SUBTYPE'
AND POLC2.LOOKUP_CODE (+) = NVL(POH.QUOTATION_CLASS_CODE
, 'CATALOG')
AND POLC2.LOOKUP_TYPE = 'QUOTATION CLASS'
AND POH1.PO_HEADER_ID (+) = POH.FROM_HEADER_ID
AND POH.TYPE_LOOKUP_CODE = 'QUOTATION'
AND LINE.PO_HEADER_ID = POH.PO_HEADER_ID
AND POV.VENDOR_ID (+) = POH.VENDOR_ID
Columns
Name |
PROJECT_ID |
TASK_ID |
PO_HEADER_ID |
QUOTATION_NUMBER |
QUOTATION_TYPE |
QUOTATION_CLASS |
QUOTATION_STATUS |
RFQ_ID |
RFQ_NUMBER |
EFFECTIVE_DATE |
EXPIRATION_DATE |
SUPPLIER_ID |
SUPPLIER_NAME |
BUYER_ID |
BUYER_NAME |