VIEW: APPS.POFV_QUOTATIONS

Source

View Text - Preformatted

SELECT qu.PO_HEADER_ID, qu.SEGMENT1, qu.ORG_ID, op.NAME, '_LA:qu.QUOTATION_CLASS_CODE:PO_LOOKUP_CODES:QUOTATION CLASS:DISPLAYED_FIELD', qt.TYPE_NAME, '_LA:qu.STATUS_LOOKUP_CODE:PO_LOOKUP_CODES:RFQ/QUOTE STATUS:DISPLAYED_FIELD', qu.COMMENTS, qu.START_DATE, qu.END_DATE, '_LA:qu.APPROVAL_REQUIRED_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', '_LA:qu.FREIGHT_TERMS_LOOKUP_CODE:PO_LOOKUP_CODES:FREIGHT TERMS:DISPLAYED_FIELD', '_LA:qu.FOB_LOOKUP_CODE:AR_LOOKUPS:FOB:MEANING', qu.RATE, qu.RATE_DATE, '_LA:qu.REPLY_METHOD_LOOKUP_CODE:PO_LOOKUP_CODES:REPLY/RECEIVE VIA:DISPLAYED_FIELD', qu.REPLY_DATE, qu.QUOTE_WARNING_DELAY, qu.NOTE_TO_VENDOR, qu.QUOTE_VENDOR_QUOTE_NUMBER, qu.PRINT_COUNT, qu.PRINTED_DATE, '_DF:PO:PO_HEADERS:qu', qu.VENDOR_ID, ve.VENDOR_NAME, qu.VENDOR_SITE_ID, vs.VENDOR_SITE_CODE, qu.VENDOR_CONTACT_ID, vc.LAST_NAME || ', ' || vc.FIRST_NAME, qu.AGENT_ID, ag.EMPLOYEE_NUMBER, ag.FULL_NAME, qu.BILL_TO_LOCATION_ID, bo.LOCATION_CODE, qu.SHIP_TO_LOCATION_ID, so.LOCATION_CODE, qu.CURRENCY_CODE, cu.NAME, qu.RATE_TYPE, rt.USER_CONVERSION_TYPE, rt.DESCRIPTION, qu.FROM_HEADER_ID, fh.SEGMENT1, qu.FROM_TYPE_LOOKUP_CODE, ft.TYPE_NAME, qu.TERMS_ID, pt.NAME, qu.SHIP_VIA_LOOKUP_CODE, fr.DESCRIPTION, fr.ORGANIZATION_ID, mp.ORGANIZATION_CODE, qu.CREATION_DATE, qu.CREATED_BY, qu.LAST_UPDATE_DATE, qu.LAST_UPDATED_BY, qu.AUTO_SOURCING_FLAG, qu.UPDATE_SOURCING_RULES_FLAG, qu.RETRO_PRICE_APPLY_UPDATES_FLAG, qu.RETRO_PRICE_COMM_UPDATES_FLAG, qu.EMAIL_ADDRESS, qu.FAX, qu.SUPPLIER_NOTIF_METHOD, qu.SUPPLIER_AUTH_ENABLED_FLAG, qu.CAT_ADMIN_AUTH_ENABLED_FLAG, qu.STYLE_ID, qu.TAX_ATTRIBUTE_UPDATE_CODE FROM PO_HEADERS_ALL QU, HR_ALL_ORGANIZATION_UNITS OP, AP_TERMS PT, FND_CURRENCIES_VL CU, GL_DAILY_CONVERSION_TYPES RT, PER_PEOPLE_F AG, HR_LOCATIONS BO, PO_HEADERS_ALL FH, PO_DOCUMENT_TYPES_ALL FT, PO_DOCUMENT_TYPES_ALL QT, HR_LOCATIONS SO, ORG_FREIGHT FR, FINANCIALS_SYSTEM_PARAMS_ALL FP, MTL_PARAMETERS MP, PO_VENDORS VE, PO_VENDOR_CONTACTS VC, PO_VENDOR_SITES_ALL VS WHERE QU.TYPE_LOOKUP_CODE = 'QUOTATION' AND QU.ORG_ID = FP.ORG_ID AND QU.ORG_ID = OP.ORGANIZATION_ID AND FP.INVENTORY_ORGANIZATION_ID = MP.ORGANIZATION_ID AND QU.TERMS_ID = PT.TERM_ID(+) AND QU.CURRENCY_CODE = CU.CURRENCY_CODE(+) AND QU.RATE_TYPE = RT.CONVERSION_TYPE(+) AND QU.AGENT_ID = AG.PERSON_ID(+) AND AG.EFFECTIVE_START_DATE(+) <= TRUNC(SYSDATE) AND AG.EFFECTIVE_END_DATE(+) >= TRUNC(SYSDATE) AND QU.BILL_TO_LOCATION_ID = BO.LOCATION_ID(+) AND QU.SHIP_TO_LOCATION_ID = SO.LOCATION_ID(+) AND QU.FROM_HEADER_ID = FH.PO_HEADER_ID(+) AND QU.FROM_TYPE_LOOKUP_CODE = FT.DOCUMENT_SUBTYPE(+) AND FT.DOCUMENT_TYPE_CODE(+) = 'RFQ' AND QU.ORG_ID = FT.ORG_ID(+) AND QU.QUOTE_TYPE_LOOKUP_CODE = QT.DOCUMENT_SUBTYPE(+) AND QT.DOCUMENT_TYPE_CODE(+) = 'QUOTATION' AND QU.ORG_ID = QT.ORG_ID(+) AND QU.SHIP_VIA_LOOKUP_CODE = FR.FREIGHT_CODE(+) AND NVL(FR.ORGANIZATION_ID, FP.INVENTORY_ORGANIZATION_ID) = FP.INVENTORY_ORGANIZATION_ID AND QU.VENDOR_ID = VE.VENDOR_ID(+) AND QU.VENDOR_SITE_ID = VS.VENDOR_SITE_ID(+) AND QU.ORG_ID = VS.ORG_ID(+) AND QU.VENDOR_CONTACT_ID = VC.VENDOR_CONTACT_ID(+) WITH READ ONLY

View Text - HTML Formatted

SELECT QU.PO_HEADER_ID
, QU.SEGMENT1
, QU.ORG_ID
, OP.NAME
, '_LA:QU.QUOTATION_CLASS_CODE:PO_LOOKUP_CODES:QUOTATION CLASS:DISPLAYED_FIELD'
, QT.TYPE_NAME
, '_LA:QU.STATUS_LOOKUP_CODE:PO_LOOKUP_CODES:RFQ/QUOTE STATUS:DISPLAYED_FIELD'
, QU.COMMENTS
, QU.START_DATE
, QU.END_DATE
, '_LA:QU.APPROVAL_REQUIRED_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:QU.FREIGHT_TERMS_LOOKUP_CODE:PO_LOOKUP_CODES:FREIGHT TERMS:DISPLAYED_FIELD'
, '_LA:QU.FOB_LOOKUP_CODE:AR_LOOKUPS:FOB:MEANING'
, QU.RATE
, QU.RATE_DATE
, '_LA:QU.REPLY_METHOD_LOOKUP_CODE:PO_LOOKUP_CODES:REPLY/RECEIVE VIA:DISPLAYED_FIELD'
, QU.REPLY_DATE
, QU.QUOTE_WARNING_DELAY
, QU.NOTE_TO_VENDOR
, QU.QUOTE_VENDOR_QUOTE_NUMBER
, QU.PRINT_COUNT
, QU.PRINTED_DATE
, '_DF:PO:PO_HEADERS:QU'
, QU.VENDOR_ID
, VE.VENDOR_NAME
, QU.VENDOR_SITE_ID
, VS.VENDOR_SITE_CODE
, QU.VENDOR_CONTACT_ID
, VC.LAST_NAME || '
, ' || VC.FIRST_NAME
, QU.AGENT_ID
, AG.EMPLOYEE_NUMBER
, AG.FULL_NAME
, QU.BILL_TO_LOCATION_ID
, BO.LOCATION_CODE
, QU.SHIP_TO_LOCATION_ID
, SO.LOCATION_CODE
, QU.CURRENCY_CODE
, CU.NAME
, QU.RATE_TYPE
, RT.USER_CONVERSION_TYPE
, RT.DESCRIPTION
, QU.FROM_HEADER_ID
, FH.SEGMENT1
, QU.FROM_TYPE_LOOKUP_CODE
, FT.TYPE_NAME
, QU.TERMS_ID
, PT.NAME
, QU.SHIP_VIA_LOOKUP_CODE
, FR.DESCRIPTION
, FR.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, QU.CREATION_DATE
, QU.CREATED_BY
, QU.LAST_UPDATE_DATE
, QU.LAST_UPDATED_BY
, QU.AUTO_SOURCING_FLAG
, QU.UPDATE_SOURCING_RULES_FLAG
, QU.RETRO_PRICE_APPLY_UPDATES_FLAG
, QU.RETRO_PRICE_COMM_UPDATES_FLAG
, QU.EMAIL_ADDRESS
, QU.FAX
, QU.SUPPLIER_NOTIF_METHOD
, QU.SUPPLIER_AUTH_ENABLED_FLAG
, QU.CAT_ADMIN_AUTH_ENABLED_FLAG
, QU.STYLE_ID
, QU.TAX_ATTRIBUTE_UPDATE_CODE
FROM PO_HEADERS_ALL QU
, HR_ALL_ORGANIZATION_UNITS OP
, AP_TERMS PT
, FND_CURRENCIES_VL CU
, GL_DAILY_CONVERSION_TYPES RT
, PER_PEOPLE_F AG
, HR_LOCATIONS BO
, PO_HEADERS_ALL FH
, PO_DOCUMENT_TYPES_ALL FT
, PO_DOCUMENT_TYPES_ALL QT
, HR_LOCATIONS SO
, ORG_FREIGHT FR
, FINANCIALS_SYSTEM_PARAMS_ALL FP
, MTL_PARAMETERS MP
, PO_VENDORS VE
, PO_VENDOR_CONTACTS VC
, PO_VENDOR_SITES_ALL VS
WHERE QU.TYPE_LOOKUP_CODE = 'QUOTATION'
AND QU.ORG_ID = FP.ORG_ID
AND QU.ORG_ID = OP.ORGANIZATION_ID
AND FP.INVENTORY_ORGANIZATION_ID = MP.ORGANIZATION_ID
AND QU.TERMS_ID = PT.TERM_ID(+)
AND QU.CURRENCY_CODE = CU.CURRENCY_CODE(+)
AND QU.RATE_TYPE = RT.CONVERSION_TYPE(+)
AND QU.AGENT_ID = AG.PERSON_ID(+)
AND AG.EFFECTIVE_START_DATE(+) <= TRUNC(SYSDATE)
AND AG.EFFECTIVE_END_DATE(+) >= TRUNC(SYSDATE)
AND QU.BILL_TO_LOCATION_ID = BO.LOCATION_ID(+)
AND QU.SHIP_TO_LOCATION_ID = SO.LOCATION_ID(+)
AND QU.FROM_HEADER_ID = FH.PO_HEADER_ID(+)
AND QU.FROM_TYPE_LOOKUP_CODE = FT.DOCUMENT_SUBTYPE(+)
AND FT.DOCUMENT_TYPE_CODE(+) = 'RFQ'
AND QU.ORG_ID = FT.ORG_ID(+)
AND QU.QUOTE_TYPE_LOOKUP_CODE = QT.DOCUMENT_SUBTYPE(+)
AND QT.DOCUMENT_TYPE_CODE(+) = 'QUOTATION'
AND QU.ORG_ID = QT.ORG_ID(+)
AND QU.SHIP_VIA_LOOKUP_CODE = FR.FREIGHT_CODE(+)
AND NVL(FR.ORGANIZATION_ID
, FP.INVENTORY_ORGANIZATION_ID) = FP.INVENTORY_ORGANIZATION_ID
AND QU.VENDOR_ID = VE.VENDOR_ID(+)
AND QU.VENDOR_SITE_ID = VS.VENDOR_SITE_ID(+)
AND QU.ORG_ID = VS.ORG_ID(+)
AND QU.VENDOR_CONTACT_ID = VC.VENDOR_CONTACT_ID(+) WITH READ ONLY