VIEW: APPS.CST_CIMP_GROUP_ID

Source

View Text - Preformatted

SELECT to_char(group_id), group_description,1 from CST_ITEM_CST_DTLS_INTERFACE WHERE group_id is not null and process_flag = 1 and error_flag is null UNION select to_char(group_id),group_description,2 from CST_RESOURCE_COSTS_INTERFACE crci where group_id is not null and process_flag = 1 and error_flag is null UNION select to_char(group_id), group_description,3 from cst_dept_overheads_interface cdoi where group_id is not null and process_flag = 1 and error_flag is null UNION select to_char(group_id), group_description,3 from cst_res_overheads_interface croi where group_id is not null and process_flag = 1 and error_flag is null

View Text - HTML Formatted

SELECT TO_CHAR(GROUP_ID)
, GROUP_DESCRIPTION
, 1
FROM CST_ITEM_CST_DTLS_INTERFACE
WHERE GROUP_ID IS NOT NULL
AND PROCESS_FLAG = 1
AND ERROR_FLAG IS NULL UNION SELECT TO_CHAR(GROUP_ID)
, GROUP_DESCRIPTION
, 2
FROM CST_RESOURCE_COSTS_INTERFACE CRCI
WHERE GROUP_ID IS NOT NULL
AND PROCESS_FLAG = 1
AND ERROR_FLAG IS NULL UNION SELECT TO_CHAR(GROUP_ID)
, GROUP_DESCRIPTION
, 3
FROM CST_DEPT_OVERHEADS_INTERFACE CDOI
WHERE GROUP_ID IS NOT NULL
AND PROCESS_FLAG = 1
AND ERROR_FLAG IS NULL UNION SELECT TO_CHAR(GROUP_ID)
, GROUP_DESCRIPTION
, 3
FROM CST_RES_OVERHEADS_INTERFACE CROI
WHERE GROUP_ID IS NOT NULL
AND PROCESS_FLAG = 1
AND ERROR_FLAG IS NULL