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_TA_BULKLOAD_PVT dependencies on MTL_ITEM_CATALOG_GROUPS

Line 510: FROM mtl_item_catalog_groups micg

506: FROM EGO_TRANS_ATTRS_VERS_INTF ETAVI
507: WHERE ETAVI.item_catalog_group_id IS NOT NULL
508: AND NOT EXISTS (
509: SELECT 1
510: FROM mtl_item_catalog_groups micg
511: WHERE micg.ITEM_CATALOG_GROUP_ID=ETAVI.ITEM_CATALOG_GROUP_ID)
512: AND ETAVI.transaction_id IS NOT NULL
513: AND ETAVI.process_status = G_PROCESS_RECORD
514: AND ((p_set_process_id IS NULL) OR (ETAVI.set_process_id=p_set_process_id));

Line 525: FROM mtl_item_catalog_groups micg

521: ETAVI.last_update_login = G_LOGIN_ID
522: WHERE ETAVI.item_catalog_group_id IS NOT NULL
523: AND NOT EXISTS (
524: SELECT 1
525: FROM mtl_item_catalog_groups micg
526: WHERE micg.ITEM_CATALOG_GROUP_ID=ETAVI.ITEM_CATALOG_GROUP_ID)
527: AND ETAVI.transaction_id IS NOT NULL
528: AND ETAVI.process_status = G_PROCESS_RECORD
529: AND ((p_set_process_id IS NULL) OR (ETAVI.set_process_id=p_set_process_id));

Line 1682: FROM mtl_item_catalog_groups_kfv icc_kfv

1678: /* NOt Req now are we are doing this in Bulk_Validate_Trans_Attrs_ICC */
1679: /*
1680: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
1681: SET item_catalog_group_id = (SELECt icc_kfv.item_catalog_group_id
1682: FROM mtl_item_catalog_groups_kfv icc_kfv
1683: where Upper(icc_kfv.concatenated_segments) = Upper(ETAVT.item_catalog_group_name)
1684: )
1685: WHERE ETAVT.item_catalog_group_name IS NOT NULL
1686: AND ETAVT.item_catalog_group_id IS NULL

Line 2032: FROM mtl_item_catalog_groups_kfv icc_kfv

2028: AND p_ta_intf_tbl(i).item_catalog_group_name IS NOT NULL) THEN
2029:
2030: BEGIN
2031: SELECt icc_kfv.item_catalog_group_id INTO p_ta_intf_tbl(i).item_catalog_group_id
2032: FROM mtl_item_catalog_groups_kfv icc_kfv
2033: WHERE Upper(icc_kfv.concatenated_segments) = Upper(p_ta_intf_tbl(i).item_catalog_group_name);
2034: EXCEPTION
2035: WHEN no_data_found THEN
2036: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'ICC '

Line 2253: FROM mtl_item_catalog_groups micg

2249: ELSIF (p_ta_intf_tbl(i).item_catalog_group_id IS NOT NULL) THEN /* if ICC_ID provided doesn't exists*/
2250:
2251: BEGIN
2252: SELECT item_catalog_group_id INTO l_id_exists
2253: FROM mtl_item_catalog_groups micg
2254: WHERE micg.ITEM_CATALOG_GROUP_ID=p_ta_intf_tbl(i).item_catalog_group_id;
2255:
2256: EXCEPTION
2257: WHEN no_data_found THEN

Line 2536: FROM mtl_item_catalog_groups_b cat

2532: ) RETURN BOOLEAN IS
2533:
2534: CURSOR c IS
2535: SELECT cat.parent_catalog_group_id
2536: FROM mtl_item_catalog_groups_b cat
2537: WHERE cat.item_catalog_group_id = p_item_catalog_group_id;
2538:
2539: l_ret mtl_item_catalog_groups_b.parent_catalog_group_id%TYPE;
2540:

Line 2539: l_ret mtl_item_catalog_groups_b.parent_catalog_group_id%TYPE;

2535: SELECT cat.parent_catalog_group_id
2536: FROM mtl_item_catalog_groups_b cat
2537: WHERE cat.item_catalog_group_id = p_item_catalog_group_id;
2538:
2539: l_ret mtl_item_catalog_groups_b.parent_catalog_group_id%TYPE;
2540:
2541: BEGIN
2542: OPEN c;
2543: FETCH c INTO l_ret;

Line 2604: FROM mtl_item_catalog_groups_b micg

2600: SELECT heir.item_catalog_group_id,
2601: heir.lev
2602: FROM (SELECT item_catalog_group_id ,
2603: level lev
2604: FROM mtl_item_catalog_groups_b micg
2605: START WITH item_catalog_group_id = p_item_catalog_group_id
2606: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
2607: ) heir
2608: WHERE heir.lev > 1 -- only parents

Line 2831: FROM mtl_item_catalog_groups

2827: x_ego_ta_tbl=>l_ego_ta_tbl);
2828:
2829: BEGIN /* Checking if ICC is child ICC */
2830: SELECT 1 INTO l_is_child_icc
2831: FROM mtl_item_catalog_groups
2832: WHERE ITEM_CATALOG_GROUP_ID=p_ta_intf_rec.item_catalog_group_id
2833: AND PARENT_CATALOG_GROUP_ID IS NOT NULL;
2834:
2835: EXCEPTION

Line 3105: mtl_item_catalog_groups_kfv icv ,

3101: FROM ego_obj_AG_assocs_b assocs ,
3102: ego_attrs_v attrs ,
3103: ego_attr_groups_v ag ,
3104: EGO_TRANS_ATTR_VERS_B versions ,
3105: mtl_item_catalog_groups_kfv icv ,
3106: (SELECT item_catalog_group_id ,
3107: LEVEL lev
3108: FROM mtl_item_catalog_groups_b START
3109: WITH item_catalog_group_id = p_item_cat_group_id CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id

Line 3108: FROM mtl_item_catalog_groups_b START

3104: EGO_TRANS_ATTR_VERS_B versions ,
3105: mtl_item_catalog_groups_kfv icv ,
3106: (SELECT item_catalog_group_id ,
3107: LEVEL lev
3108: FROM mtl_item_catalog_groups_b START
3109: WITH item_catalog_group_id = p_item_cat_group_id CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
3110: ) hier
3111: WHERE ag.attr_group_type = 'EGO_ITEM_TRANS_ATTR_GROUP'
3112: AND assocs.attr_group_id = ag.attr_group_id

Line 3174: FROM MTL_ITEM_CATALOG_GROUPS_B START

3170: FROM EGO_TRANS_ATTR_VERS_B VERSIONS,
3171: EGO_ATTRS_V ATTRS ,
3172: (SELECT ITEM_CATALOG_GROUP_ID ,
3173: LEVEL LEV
3174: FROM MTL_ITEM_CATALOG_GROUPS_B START
3175: WITH ITEM_CATALOG_GROUP_ID = p_item_cat_group_id CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID =ITEM_CATALOG_GROUP_ID
3176: ) HIER
3177: WHERE HIER.ITEM_CATALOG_GROUP_ID = versions.item_catalog_group_id
3178: AND attrs.attr_id = versions.attr_id

Line 3254: FROM MTL_ITEM_CATALOG_GROUPS_B

3250: Hier.lev
3251: FROM EGO_TRANS_ATTR_VERS_B VERSIONS,
3252: (SELECT ITEM_CATALOG_GROUP_ID ,
3253: LEVEL LEV
3254: FROM MTL_ITEM_CATALOG_GROUPS_B
3255: START WITH ITEM_CATALOG_GROUP_ID = p_item_cat_group_id
3256: CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID =ITEM_CATALOG_GROUP_ID
3257: ) HIER
3258: WHERE HIER.ITEM_CATALOG_GROUP_ID = versions.item_catalog_group_id