View: CST_CIMP_GROUP_ID

Product:	BOM - Bills of Material
Description:
Implementation/DBA Data:	APPS.CST_CIMP_GROUP_ID

View Text

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

Columns