View: PO_RFQQT_DOCUMENT_TYPES_ALL_V

Product:	PO - Purchasing
Description:	10SC ONLY - Retrofitted
Implementation/DBA Data:	APPS.PO_RFQQT_DOCUMENT_TYPES_ALL_V

View Text

SELECT PODT.TYPE_NAME
, PODB.DOCUMENT_TYPE_CODE
, PODB.DOCUMENT_SUBTYPE
, PODB.QUOTATION_CLASS_CODE
, POLC.DISPLAYED_FIELD
, PODB.ORG_ID
FROM PO_DOCUMENT_TYPES_ALL_TL PODT
, PO_DOCUMENT_TYPES_ALL_B PODB
, PO_LOOKUP_CODES POLC
WHERE POLC.LOOKUP_TYPE = 'QUOTATION CLASS'
AND POLC.LOOKUP_CODE = PODB.QUOTATION_CLASS_CODE
AND PODB.DISABLED_FLAG = 'N'
AND PODB.DOCUMENT_TYPE_CODE = PODT.DOCUMENT_TYPE_CODE
AND PODB.DOCUMENT_SUBTYPE = PODT.DOCUMENT_SUBTYPE
AND PODT.LANGUAGE = USERENV('LANG')
AND PODT.ORG_ID = PODB.ORG_ID

Columns