VIEW: APPS.FIIBV_AP_HOLD_HOLD_TYPE_LCV

Source

View Text - Preformatted

SELECT lc.lookup_code HOLD_TYPE_PK, 'ALL' ALL_FK, substrb(edw_instance.get_code,1,40) INSTANCE, lc.displayed_field NAME, lc.displayed_field HOLD_TYPE, lc.description DESCRIPTION, NVL(lc.start_date_active, SYSDATE-1) LAST_UPDATE_DATE, NVL(lc.start_date_active, SYSDATE-1) CREATION_DATE, NULL DELETION_DATE, NULL HOLD_TYPE_DP, '_DF:FND:FND_COMMON_LOOKUPS:fnd' from ap_lookup_codes lc, FND_LOOKUP_VALUES fnd WHERE lc.lookup_type = 'HOLD TYPE' and lc.lookup_type=fnd.lookup_type and lc.lookup_code=fnd.lookup_code and lc.displayed_field=fnd.meaning and (lc.lookup_code like '%HOLD%' OR lc.lookup_code = 'INSUFFICIENT INFORMATION')

View Text - HTML Formatted

SELECT LC.LOOKUP_CODE HOLD_TYPE_PK
, 'ALL' ALL_FK
, SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40) INSTANCE
, LC.DISPLAYED_FIELD NAME
, LC.DISPLAYED_FIELD HOLD_TYPE
, LC.DESCRIPTION DESCRIPTION
, NVL(LC.START_DATE_ACTIVE
, SYSDATE-1) LAST_UPDATE_DATE
, NVL(LC.START_DATE_ACTIVE
, SYSDATE-1) CREATION_DATE
, NULL DELETION_DATE
, NULL HOLD_TYPE_DP
, '_DF:FND:FND_COMMON_LOOKUPS:FND'
FROM AP_LOOKUP_CODES LC
, FND_LOOKUP_VALUES FND
WHERE LC.LOOKUP_TYPE = 'HOLD TYPE'
AND LC.LOOKUP_TYPE=FND.LOOKUP_TYPE
AND LC.LOOKUP_CODE=FND.LOOKUP_CODE
AND LC.DISPLAYED_FIELD=FND.MEANING
AND (LC.LOOKUP_CODE LIKE '%HOLD%' OR LC.LOOKUP_CODE = 'INSUFFICIENT INFORMATION')