VIEW: APPS.IGI_AP_PO_LOOKUP_CODES_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')