eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_ODI_PUB dependencies on EGO_MTL_CATALOG_GRP_VERS_B

Line 6142: FROM EGO_MTL_CATALOG_GRP_VERS_B iccb,

6138: SELECT cp_icc_id ITEM_CATALOG_GROUP_ID,cp_icc_ver VERSION_SEQ_ID,1 lev FROM dual
6139: UNION
6140: SELECT ITEM_CATALOG_GROUP_ID,VERSION_SEQ_ID,lev FROM
6141: ( SELECT iccb.ITEM_CATALOG_GROUP_ID,VERSION_SEQ_ID ,lev
6142: FROM EGO_MTL_CATALOG_GRP_VERS_B iccb,
6143: ( SELECT ITEM_CATALOG_GROUP_ID,LEVEL lev
6144: FROM MTL_ITEM_CATALOG_GROUPS_B
6145: START WITH ITEM_CATALOG_GROUP_ID =cp_icc_id
6146: CONNECT BY PRIOR ITEM_CATALOG_GROUP_ID=PARENT_CATALOG_GROUP_ID

Line 6159: FROM EGO_MTL_CATALOG_GRP_VERS_B

6155: LEV > 1
6156: AND (item_catalog_group_id, VERSION_SEQ_ID)
6157: IN
6158: ( SELECT item_catalog_group_id,VERSION_SEQ_ID
6159: FROM EGO_MTL_CATALOG_GRP_VERS_B
6160: WHERE (item_catalog_group_id,start_active_date )
6161: IN
6162: ( SELECT item_catalog_group_id, MAX(start_active_date) start_active_date
6163: FROM EGO_MTL_CATALOG_GRP_VERS_B

Line 6163: FROM EGO_MTL_CATALOG_GRP_VERS_B

6159: FROM EGO_MTL_CATALOG_GRP_VERS_B
6160: WHERE (item_catalog_group_id,start_active_date )
6161: IN
6162: ( SELECT item_catalog_group_id, MAX(start_active_date) start_active_date
6163: FROM EGO_MTL_CATALOG_GRP_VERS_B
6164: WHERE version_seq_id > 0
6165: AND start_active_date <= (
6166: SELECT nvl(end_active_date,SYSDATE)
6167: FROM EGO_MTL_CATALOG_GRP_VERS_B

Line 6167: FROM EGO_MTL_CATALOG_GRP_VERS_B

6163: FROM EGO_MTL_CATALOG_GRP_VERS_B
6164: WHERE version_seq_id > 0
6165: AND start_active_date <= (
6166: SELECT nvl(end_active_date,SYSDATE)
6167: FROM EGO_MTL_CATALOG_GRP_VERS_B
6168: WHERE ITEM_CATALOG_GROUP_ID =cp_icc_id
6169: AND VERSION_SEQ_ID =cp_icc_ver
6170:
6171: )

Line 6175: FROM EGO_MTL_CATALOG_GRP_VERS_B

6171: )
6172: GROUP BY item_catalog_group_id
6173: HAVING MAX(start_active_date)<=(
6174: SELECT nvl(end_active_date,SYSDATE)
6175: FROM EGO_MTL_CATALOG_GRP_VERS_B
6176: WHERE ITEM_CATALOG_GROUP_ID =cp_icc_id
6177: AND VERSION_SEQ_ID = cp_icc_ver
6178:
6179: )

Line 6188: FROM EGO_MTL_CATALOG_GRP_VERS_B iccb,

6184: )
6185: UNION
6186: SELECT ITEM_CATALOG_GROUP_ID,VERSION_SEQ_ID,lev FROM
6187: ( SELECT iccb.ITEM_CATALOG_GROUP_ID,VERSION_SEQ_ID ,lev
6188: FROM EGO_MTL_CATALOG_GRP_VERS_B iccb,
6189: ( SELECT ITEM_CATALOG_GROUP_ID,LEVEL lev
6190: FROM MTL_ITEM_CATALOG_GROUPS_B
6191: START WITH ITEM_CATALOG_GROUP_ID =cp_icc_id
6192: CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID=ITEM_CATALOG_GROUP_ID

Line 6206: FROM EGO_MTL_CATALOG_GRP_VERS_B

6202: LEV > 1
6203: AND (item_catalog_group_id, VERSION_SEQ_ID)
6204: IN
6205: ( SELECT item_catalog_group_id,VERSION_SEQ_ID
6206: FROM EGO_MTL_CATALOG_GRP_VERS_B
6207: WHERE (item_catalog_group_id,start_active_date )
6208: IN
6209: ( SELECT item_catalog_group_id, MAX(start_active_date) start_active_date
6210: FROM EGO_MTL_CATALOG_GRP_VERS_B

Line 6210: FROM EGO_MTL_CATALOG_GRP_VERS_B

6206: FROM EGO_MTL_CATALOG_GRP_VERS_B
6207: WHERE (item_catalog_group_id,start_active_date )
6208: IN
6209: ( SELECT item_catalog_group_id, MAX(start_active_date) start_active_date
6210: FROM EGO_MTL_CATALOG_GRP_VERS_B
6211: WHERE creation_date <= ( SELECT CREATION_DATE
6212: FROM EGO_MTL_CATALOG_GRP_VERS_B
6213: WHERE ITEM_CATALOG_GROUP_ID = cp_icc_id
6214: AND VERSION_SEQ_ID = cp_icc_ver

Line 6212: FROM EGO_MTL_CATALOG_GRP_VERS_B

6208: IN
6209: ( SELECT item_catalog_group_id, MAX(start_active_date) start_active_date
6210: FROM EGO_MTL_CATALOG_GRP_VERS_B
6211: WHERE creation_date <= ( SELECT CREATION_DATE
6212: FROM EGO_MTL_CATALOG_GRP_VERS_B
6213: WHERE ITEM_CATALOG_GROUP_ID = cp_icc_id
6214: AND VERSION_SEQ_ID = cp_icc_ver
6215: )
6216: AND version_seq_id > 0

Line 6219: FROM EGO_MTL_CATALOG_GRP_VERS_B

6215: )
6216: AND version_seq_id > 0
6217: AND start_active_date <= (
6218: SELECT CREATION_DATE
6219: FROM EGO_MTL_CATALOG_GRP_VERS_B
6220: WHERE ITEM_CATALOG_GROUP_ID =cp_icc_id
6221: AND VERSION_SEQ_ID = cp_icc_ver
6222:
6223: )

Line 6227: FROM EGO_MTL_CATALOG_GRP_VERS_B

6223: )
6224: GROUP BY item_catalog_group_id
6225: HAVING MAX(start_active_date)<=(
6226: SELECT CREATION_DATE
6227: FROM EGO_MTL_CATALOG_GRP_VERS_B
6228: WHERE ITEM_CATALOG_GROUP_ID =cp_icc_id
6229: AND VERSION_SEQ_ID = cp_icc_ver
6230:
6231: )

Line 6384: FROM EGO_MTL_CATALOG_GRP_VERS_B

6380: BEGIN
6381: SELECT version_seq_id INTO l_dup_icc_ver_tab(i)
6382: FROM
6383: ( SELECT item_catalog_group_id,version_seq_id,MAX(start_active_date) start_active_date
6384: FROM EGO_MTL_CATALOG_GRP_VERS_B
6385: WHERE NVL(end_active_date, sysdate) >= SYSDATE
6386: AND start_active_date <= SYSDATE
6387: AND ITEM_CATALOG_GROUP_ID = l_dup_icc_id_tab(i)
6388: AND version_seq_id > 0

Line 6473: FROM EGO_MTL_CATALOG_GRP_VERS_B

6469: BEGIN
6470: SELECT version_seq_id INTO l_dup_icc_ver_tab(i)
6471: FROM
6472: ( SELECT item_catalog_group_id,version_seq_id,MAX(start_active_date) start_active_date
6473: FROM EGO_MTL_CATALOG_GRP_VERS_B
6474: WHERE NVL(end_active_date, sysdate) >= SYSDATE
6475: AND start_active_date <= SYSDATE
6476: AND ITEM_CATALOG_GROUP_ID = l_dup_icc_id_tab(i)
6477: AND version_seq_id > 0

Line 7171: FROM mtl_item_catalog_groups_b base ,EGO_MTL_CATALOG_GRP_VERS_B vers

7167: CURSOR cur_ver_icc(cp_item_catalog_group_id NUMBER,
7168: cp_version_seq_id NUMBER)
7169: IS
7170: SELECT Count(base.item_catalog_group_id) ver_icc_count
7171: FROM mtl_item_catalog_groups_b base ,EGO_MTL_CATALOG_GRP_VERS_B vers
7172: WHERE base.item_catalog_group_id= vers.item_catalog_group_id
7173: AND base.item_catalog_group_id=cp_item_catalog_group_id
7174: AND vers.version_seq_id=Nvl(cp_version_seq_id,vers.version_seq_id)
7175: AND vers.version_seq_id>0; --Yjain

Line 7444: FROM EGO_MTL_CATALOG_GRP_VERS_B

7440: ( LEV = 1 AND ICC_VERSION_number =cp_icc_version_number )
7441: OR
7442: ( LEV > 1 AND ( item_catalog_group_id, ICC_VERSION_NUMBER )
7443: IN ( SELECT item_catalog_group_id, VERSION_SEQ_ID
7444: FROM EGO_MTL_CATALOG_GRP_VERS_B
7445: WHERE (item_catalog_group_id,start_active_date )
7446: IN
7447: (SELECT item_catalog_group_id, MAX(start_active_date) start_active_date
7448: FROM EGO_MTL_CATALOG_GRP_VERS_B

Line 7448: FROM EGO_MTL_CATALOG_GRP_VERS_B

7444: FROM EGO_MTL_CATALOG_GRP_VERS_B
7445: WHERE (item_catalog_group_id,start_active_date )
7446: IN
7447: (SELECT item_catalog_group_id, MAX(start_active_date) start_active_date
7448: FROM EGO_MTL_CATALOG_GRP_VERS_B
7449: WHERE creation_date <= cp_creation_date
7450: AND version_seq_id > 0
7451: AND start_active_date <= cp_start_active_date
7452: GROUP BY item_catalog_group_id

Line 7487: FROM EGO_MTL_CATALOG_GRP_VERS_B

7483:
7484: --Finding out start effcetive date and creation date of ICC Version
7485: --Dbms_Output.put_line(' In Loop for POPULATE_TRANS_ATTR_LIST j.icc_id = '|| j.icc_id || ' Ver '|| j.icc_ver );
7486: SELECT Nvl(START_ACTIVE_DATE,SYSDATE) ,CREATION_DATE INTO l_icc_start_active_date, l_icc_create_date
7487: FROM EGO_MTL_CATALOG_GRP_VERS_B
7488: WHERE ITEM_CATALOG_GROUP_ID = j.icc_id AND VERSION_SEQ_ID = j.icc_ver;
7489:
7490:
7491: FOR k IN Cur_TA_List(j.icc_id,j.icc_ver,l_icc_create_date,l_icc_start_active_date)