VIEW: APPS.FIIBV_AP_RLSE_RELEASE_LCV

Source

View Text - Preformatted

SELECT ahc.hold_lookup_code RELEASE_PK, ahc.hold_type RELEASE_TYPE_FK, substrb(edw_instance.get_code,1,40) INSTANCE, alc.displayed_field NAME, alc.displayed_field RELEASE_NAME, ahc.user_releaseable_flag USER_RELEASEABLE_FLAG, ahc.user_updateable_flag USER_UPDATEABLE_FLAG, ahc.postable_flag POSTABLE_FLAG, ahc.inactive_date INACTIVE_DATE, alc.description DESCRIPTION, ahc.last_update_date LAST_UPDATE_DATE, ahc.creation_date CREATION_DATE, NULL DELETION_DATE, NULL RELEASE_DP, '_DF:FND:FND_COMMON_LOOKUPS:fnd' from ap_lookup_codes alc, ap_hold_codes ahc, FND_LOOKUP_VALUES fnd WHERE ahc.hold_lookup_code = alc.lookup_code and alc.lookup_type=fnd.lookup_type and alc.lookup_code=fnd.lookup_code and alc.displayed_field=fnd.meaning and (ahc.hold_type like '%RELEASE%' OR ahc.hold_type = 'SUFFICIENT INFORMATION') and alc.lookup_type = 'HOLD CODE'

View Text - HTML Formatted

SELECT AHC.HOLD_LOOKUP_CODE RELEASE_PK
, AHC.HOLD_TYPE RELEASE_TYPE_FK
, SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40) INSTANCE
, ALC.DISPLAYED_FIELD NAME
, ALC.DISPLAYED_FIELD RELEASE_NAME
, AHC.USER_RELEASEABLE_FLAG USER_RELEASEABLE_FLAG
, AHC.USER_UPDATEABLE_FLAG USER_UPDATEABLE_FLAG
, AHC.POSTABLE_FLAG POSTABLE_FLAG
, AHC.INACTIVE_DATE INACTIVE_DATE
, ALC.DESCRIPTION DESCRIPTION
, AHC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AHC.CREATION_DATE CREATION_DATE
, NULL DELETION_DATE
, NULL RELEASE_DP
, '_DF:FND:FND_COMMON_LOOKUPS:FND'
FROM AP_LOOKUP_CODES ALC
, AP_HOLD_CODES AHC
, FND_LOOKUP_VALUES FND
WHERE AHC.HOLD_LOOKUP_CODE = ALC.LOOKUP_CODE
AND ALC.LOOKUP_TYPE=FND.LOOKUP_TYPE
AND ALC.LOOKUP_CODE=FND.LOOKUP_CODE
AND ALC.DISPLAYED_FIELD=FND.MEANING
AND (AHC.HOLD_TYPE LIKE '%RELEASE%' OR AHC.HOLD_TYPE = 'SUFFICIENT INFORMATION')
AND ALC.LOOKUP_TYPE = 'HOLD CODE'