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.INV_EGO_REVISION_VALIDATE dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 100: FROM mtl_item_catalog_groups_b ic

96: AND lc.object_type = 'PA_STRUCTURES'
97: AND eotl.object_id = o.object_id
98: AND eotl.object_classification_code in
99: ( SELECT to_char(ic.item_catalog_group_id)
100: FROM mtl_item_catalog_groups_b ic
101: CONNECT BY PRIOR ic.parent_catalog_group_id = ic.item_catalog_group_id
102: START WITH ic.item_catalog_group_id = p_catalog_group_id
103: )
104: AND o.obj_name = 'EGO_ITEM';

Line 260: FROM mtl_item_Catalog_groups_b

256: ,cp_status_code VARCHAR2)IS
257: SELECT 'Y'
258: FROM DUAL
259: WHERE EXISTS ( SELECT NULL
260: FROM mtl_item_Catalog_groups_b
261: WHERE NVL(NEW_ITEM_REQUEST_REQD,'N') = 'Y'
262: AND item_Catalog_group_id = P_Catalog_Group_Id)
263: --4932389 : Perf fixes for lifecycle-phase-status queries.
264: OR EXISTS (SELECT NULL

Line 761: FROM mtl_item_Catalog_groups_b

757: IS
758: SELECT 'Y'
759: FROM DUAL
760: WHERE EXISTS ( SELECT NULL
761: FROM mtl_item_Catalog_groups_b
762: WHERE NVL(NEW_ITEM_REQUEST_REQD,'N') = 'Y'
763: AND item_Catalog_group_id = cp_catalog_group_id
764: )
765: AND EXISTS ( SELECT NULL

Line 2089: FROM MTL_ITEM_CATALOG_GROUPS_B

2085: /*
2086: CURSOR c_parent_catalogs(cp_catalog_group_id NUMBER) IS
2087: SELECT ITEM_CATALOG_GROUP_ID
2088: ,PARENT_CATALOG_GROUP_ID
2089: FROM MTL_ITEM_CATALOG_GROUPS_B
2090: CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID
2091: START WITH ITEM_CATALOG_GROUP_ID = cp_catalog_group_id;
2092: */
2093:

Line 3007: FROM MTL_ITEM_CATALOG_GROUPS_B ICC

3003: /* R12C : Introducing cursor for hierarchy enabled Catalogs */
3004: CURSOR c_nir_reqd (cp_item_catalog_group_id IN NUMBER)
3005: IS
3006: SELECT ICC.NEW_ITEM_REQUEST_REQD
3007: FROM MTL_ITEM_CATALOG_GROUPS_B ICC
3008: WHERE ICC.NEW_ITEM_REQUEST_REQD IS NOT NULL
3009: AND ICC.NEW_ITEM_REQUEST_REQD <> 'I'
3010: CONNECT BY PRIOR ICC.PARENT_CATALOG_GROUP_ID = ICC.ITEM_CATALOG_GROUP_ID
3011: START WITH ICC.ITEM_CATALOG_GROUP_ID = cp_item_catalog_group_id

Line 3081: FROM mtl_item_catalog_groups_b icc

3077: AND mp.organization_id = interface.organization_id
3078: AND mp.organization_id = mp.master_organization_id
3079: AND 'Y' =
3080: (SELECT icc.new_item_request_reqd
3081: FROM mtl_item_catalog_groups_b icc
3082: WHERE icc.new_item_request_reqd IS NOT NULL
3083: AND icc.new_item_request_reqd <> 'I'
3084: AND ROWNUM = 1
3085: CONNECT BY PRIOR

Line 3122: -- MTL_ITEM_CATALOG_GROUPS_B micb,

3118: SET msii.process_flag = 5
3119: WHERE msii.ROWID IN
3120: ( SELECT interface.ROWID
3121: FROM mtl_system_items_interface interface,
3122: -- MTL_ITEM_CATALOG_GROUPS_B micb,
3123: MTL_PARAMETERS mp
3124: WHERE interface.SET_PROCESS_ID = p_set_process_id
3125: AND interface.PROCESS_FLAG = 4
3126: AND interface.TRANSACTION_TYPE = 'CREATE'

Line 3134: FROM MTL_ITEM_CATALOG_GROUPS_B ICC

3130: AND mp.organization_id = interface.organization_id
3131: AND interface.organization_id = mp.master_organization_id
3132: AND 'Y' =
3133: ( SELECT ICC.NEW_ITEM_REQUEST_REQD
3134: FROM MTL_ITEM_CATALOG_GROUPS_B ICC
3135: WHERE ICC.NEW_ITEM_REQUEST_REQD IS NOT NULL
3136: AND ICC.NEW_ITEM_REQUEST_REQD <> 'I'
3137: AND ROWNUM = 1
3138: CONNECT BY PRIOR ICC.PARENT_CATALOG_GROUP_ID = ICC.ITEM_CATALOG_GROUP_ID

Line 3198: MTL_ITEM_CATALOG_GROUPS_B micb,

3194: interface.rowid,
3195: micb.NEW_ITEM_REQ_CHANGE_TYPE_ID,
3196: mp.ORGANIZATION_CODE
3197: FROM MTL_SYSTEM_ITEMS_INTERFACE interface,
3198: MTL_ITEM_CATALOG_GROUPS_B micb,
3199: MTL_PARAMETERS mp
3200: WHERE interface.SET_PROCESS_ID = cp_set_process_id
3201: AND interface.PROCESS_FLAG = 4
3202: AND interface.TRANSACTION_TYPE = 'CREATE'

Line 3449: FROM mtl_item_catalog_groups_b

3445: ,x_err_text OUT NOCOPY VARCHAR2) RETURN INTEGER IS
3446:
3447: CURSOR c_get_nir_setup(cp_item_catalog_group_id IN NUMBER) IS
3448: SELECT new_item_request_reqd
3449: FROM mtl_item_catalog_groups_b
3450: WHERE new_item_request_reqd IS NOT NULL
3451: AND new_item_request_reqd <> 'I'
3452: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
3453: START WITH item_catalog_group_id = cp_item_catalog_group_id

Line 3817: FROM mtl_item_catalog_groups_b

3813: FROM mtl_parameters
3814: WHERE organization_id = p_organization_id;
3815:
3816: SELECT new_item_req_change_type_id INTO l_type_id
3817: FROM mtl_item_catalog_groups_b
3818: WHERE item_catalog_group_id = p_item_catalog_group_id;
3819:
3820: UPDATE MTL_SYSTEM_ITEMS_B
3821: SET INVENTORY_ITEM_STATUS_CODE='Pending'

Line 4186: FROM mtl_item_catalog_groups_b

4182: SELECT count(*) INTO l_valid_icc
4183: FROM ego_obj_attr_grp_assocs_v
4184: WHERE variant = 'Y'
4185: AND classification_code IN ( SELECT to_char(item_catalog_group_id)
4186: FROM mtl_item_catalog_groups_b
4187: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
4188: START WITH item_catalog_group_id = l_msii_icc_id );
4189:
4190: IF l_valid_icc = 0 THEN