[Home] [Help]
View: PO_RFQS_FOR_QUOTE_ALL_V
View Text
SELECT POH.SEGMENT1
, POLC.DISPLAYED_FIELD
, POH.RFQ_CLOSE_DATE
, POH.COMMENTS
, POH.PO_HEADER_ID
, POH.TYPE_LOOKUP_CODE
, POH.APPROVAL_REQUIRED_FLAG
, PORV.VENDOR_SITE_ID
, POVS.VENDOR_SITE_CODE
, PORV.VENDOR_ID
, POV.VENDOR_NAME
, POH.QUOTATION_CLASS_CODE
, POH.ORG_ID
FROM PO_LOOKUP_CODES POLC
, PO_HEADERS POH
, PO_RFQ_VENDORS PORV
, PO_VENDORS POV
, PO_VENDOR_SITES_ALL POVS
WHERE POLC.LOOKUP_CODE = POH.STATUS_LOOKUP_CODE
AND POH.STATUS_LOOKUP_CODE <> 'C'
AND POLC.LOOKUP_TYPE ='RFQ/QUOTE STATUS'
AND PORV.PO_HEADER_ID = POH.PO_HEADER_ID
AND PORV.VENDOR_ID = POV.VENDOR_ID
AND PORV.VENDOR_SITE_ID = POVS.VENDOR_SITE_ID
AND POH.TYPE_LOOKUP_CODE = 'RFQ'
AND POH.ORG_ID = POVS.ORG_ID
Columns
Name |
SEGMENT1 |
DISPLAYED_FIELD |
RFQ_CLOSE_DATE |
COMMENTS |
PO_HEADER_ID |
TYPE_LOOKUP_CODE |
APPROVAL_REQUIRED_FLAG |
VENDOR_SITE_ID |
VENDOR_SITE_CODE |
VENDOR_ID |
VENDOR_NAME |
QUOTATION_CLASS_CODE |
ORG_ID |