APPS.INV_EGO_REVISION_VALIDATE dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 96: FROM mtl_item_catalog_groups_b ic

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

Line 256: FROM mtl_item_Catalog_groups_b

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

Line 272: FROM mtl_item_Catalog_groups_b

268: Cursor c_check_item_type IS
269: SELECT 'Y'
270: FROM DUAL
271: WHERE EXISTS ( SELECT NULL
272: FROM mtl_item_Catalog_groups_b
273: WHERE NVL(NEW_ITEM_REQUEST_REQD,'N') = 'Y'
274: AND item_Catalog_group_id = P_Catalog_Group_Id
275: )
276: AND EXISTS ( SELECT NULL

Line 1989: FROM MTL_ITEM_CATALOG_GROUPS_B

1985: /*
1986: CURSOR c_parent_catalogs(cp_catalog_group_id NUMBER) IS
1987: SELECT ITEM_CATALOG_GROUP_ID
1988: ,PARENT_CATALOG_GROUP_ID
1989: FROM MTL_ITEM_CATALOG_GROUPS_B
1990: CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID
1991: START WITH ITEM_CATALOG_GROUP_ID = cp_catalog_group_id;
1992: */
1993:

Line 2836: FROM MTL_ITEM_CATALOG_GROUPS_B ICC

2832: /* R12C : Introducing cursor for hierarchy enabled Catalogs */
2833: CURSOR c_nir_reqd (cp_item_catalog_group_id IN NUMBER)
2834: IS
2835: SELECT ICC.NEW_ITEM_REQUEST_REQD
2836: FROM MTL_ITEM_CATALOG_GROUPS_B ICC
2837: WHERE ICC.NEW_ITEM_REQUEST_REQD IS NOT NULL
2838: AND ICC.NEW_ITEM_REQUEST_REQD <> 'I'
2839: CONNECT BY PRIOR ICC.PARENT_CATALOG_GROUP_ID = ICC.ITEM_CATALOG_GROUP_ID
2840: START WITH ICC.ITEM_CATALOG_GROUP_ID = cp_item_catalog_group_id

Line 2912: -- MTL_ITEM_CATALOG_GROUPS_B micb,

2908: SET msii.process_flag = 5
2909: WHERE msii.ROWID IN
2910: ( SELECT interface.ROWID
2911: FROM mtl_system_items_interface interface,
2912: -- MTL_ITEM_CATALOG_GROUPS_B micb,
2913: MTL_PARAMETERS mp
2914: WHERE interface.SET_PROCESS_ID = p_set_process_id
2915: AND interface.PROCESS_FLAG = 4
2916: AND interface.TRANSACTION_TYPE = 'CREATE'

Line 2924: FROM MTL_ITEM_CATALOG_GROUPS_B ICC

2920: AND mp.organization_id = interface.organization_id
2921: AND interface.organization_id = mp.master_organization_id
2922: AND 'Y' =
2923: ( SELECT ICC.NEW_ITEM_REQUEST_REQD
2924: FROM MTL_ITEM_CATALOG_GROUPS_B ICC
2925: WHERE ICC.NEW_ITEM_REQUEST_REQD IS NOT NULL
2926: AND ICC.NEW_ITEM_REQUEST_REQD <> 'I'
2927: AND ROWNUM = 1
2928: CONNECT BY PRIOR ICC.PARENT_CATALOG_GROUP_ID = ICC.ITEM_CATALOG_GROUP_ID

Line 2988: MTL_ITEM_CATALOG_GROUPS_B micb,

2984: interface.rowid,
2985: micb.NEW_ITEM_REQ_CHANGE_TYPE_ID,
2986: mp.ORGANIZATION_CODE
2987: FROM MTL_SYSTEM_ITEMS_INTERFACE interface,
2988: MTL_ITEM_CATALOG_GROUPS_B micb,
2989: MTL_PARAMETERS mp
2990: WHERE interface.SET_PROCESS_ID = cp_set_process_id
2991: AND interface.PROCESS_FLAG = 4
2992: AND interface.TRANSACTION_TYPE = 'CREATE'

Line 3228: FROM mtl_item_catalog_groups_b

3224: ,x_err_text OUT NOCOPY VARCHAR2) RETURN INTEGER IS
3225:
3226: CURSOR c_get_nir_setup(cp_item_catalog_group_id IN NUMBER) IS
3227: SELECT new_item_request_reqd
3228: FROM mtl_item_catalog_groups_b
3229: WHERE new_item_request_reqd IS NOT NULL
3230: AND new_item_request_reqd <> 'I'
3231: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
3232: START WITH item_catalog_group_id = cp_item_catalog_group_id

Line 3596: FROM mtl_item_catalog_groups_b

3592: FROM mtl_parameters
3593: WHERE organization_id = p_organization_id;
3594:
3595: SELECT new_item_req_change_type_id INTO l_type_id
3596: FROM mtl_item_catalog_groups_b
3597: WHERE item_catalog_group_id = p_item_catalog_group_id;
3598:
3599: UPDATE MTL_SYSTEM_ITEMS_B
3600: SET INVENTORY_ITEM_STATUS_CODE='Pending'

Line 3926: FROM mtl_item_catalog_groups_b

3922: SELECT count(*) INTO l_valid_icc
3923: FROM ego_obj_attr_grp_assocs_v
3924: WHERE variant = 'Y'
3925: AND classification_code IN ( SELECT to_char(item_catalog_group_id)
3926: FROM mtl_item_catalog_groups_b
3927: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
3928: START WITH item_catalog_group_id = l_msii_icc_id );
3929:
3930: IF l_valid_icc = 0 THEN