View: IGI_AP_PO_LOOKUP_CODES_V

Product:	IGI - Public Sector Financials International
Description:	This view displays lookup codes shared by Purchasing and Payables.
Implementation/DBA Data:	APPS.IGI_AP_PO_LOOKUP_CODES_V

View Text

SELECT B.DISPLAYED_FIELD AS DISPLAYED_LOOKUP_TYPE
, A.LOOKUP_CODE AS LOOKUP_CODE
, A.DISPLAYED_FIELD AS DISPLAYED_FIELD
, A.LOOKUP_TYPE AS LOOKUP_TYPE
, A.DESCRIPTION AS DESCRIPTION
, A.INACTIVE_DATE AS INACTIVE_DATE
, 200 AS APPLICATION_ID
, A.ROWID AS ROW_ID
FROM PO_LOOKUP_CODES A
, PO_LOOKUP_CODES B
WHERE B.LOOKUP_CODE = A.LOOKUP_TYPE
AND A.LOOKUP_TYPE IN (SELECT LOOKUP_TYPE
FROM AP_LOOKUP_TYPES
WHERE USER_UPDATABLE_FLAG = 'Y') UNION SELECT D.DISPLAYED_FIELD AS DISPLAYED_LOOKUP_TYPE
, C.LOOKUP_CODE AS LOOKUP_CODE
, C.DISPLAYED_FIELD AS DISPLAYED_FIELD
, C.LOOKUP_TYPE AS LOOKUP_TYPE
, C.DESCRIPTION AS DESCRIPTION
, C.INACTIVE_DATE AS INACTIVE_DATE
, 201 AS APPLICATION_ID
, C.ROWID AS ROW_ID
FROM PO_LOOKUP_CODES C
, PO_LOOKUP_CODES D
WHERE D.LOOKUP_CODE = C.LOOKUP_TYPE
AND C.LOOKUP_TYPE IN ('PAY GROUP'
, 'VENDOR TYPE'
, 'SHIP VIA'
, 'FOB'
, 'MINORITY GROUP'
, 'FREIGHT TERMS')

Columns