DBA Data[Home] [Help]

APPS.AMS_LISTIMPORT_PVT dependencies on AMS_EVENT_MAPPING_V

Line 15087: FROM ams_event_mapping_v

15083: DECODE(GREATEST(lengthb(nvl(LTRIM(RTRIM(REG_LINE_OF_BUSINESS)),'x')),240) - 240,0,' ','REG_LINE_OF_BUSINESS:'||l_invalid_size||'(240)') REG_LINE_OF_BUSINESS,
15084: DECODE(GREATEST(lengthb(nvl(LTRIM(RTRIM(ATT_SERVEY_NOTES)),'x')),240) - 240,0,' ','ATT_SERVEY_NOTES:'||l_invalid_size||'(240)') ATT_SERVEY_NOTES,
15085: DECODE(GREATEST(lengthb(nvl(LTRIM(RTRIM(ATT_LINE_OF_BUSINESS)),'x')),240) - 240,0,' ','ATT_LINE_OF_BUSINESS:'||l_invalid_size||'(240)') ATT_LINE_OF_BUSINESS,
15086: DECODE(GREATEST(lengthb(nvl(LTRIM(RTRIM(REG_SERVEY_NOTES)),'x')),240) - 240,0,' ','REG_SERVEY_NOTES:'||l_invalid_size||'(240)') REG_SERVEY_NOTES
15087: FROM ams_event_mapping_v
15088: WHERE import_list_header_id = p_import_list_header_id
15089: and load_status in ('ACTIVE','RELOAD')
15090: and
15091: (