APPS.INV_ITEM_DATA_SCRIPTS dependencies on MTL_PARAMETERS

Line 74: FROM mtl_parameters

70:
71: /*Retrieves all Master Orgs*/
72: CURSOR master_org_cur IS
73: SELECT master_organization_id
74: FROM mtl_parameters
75: WHERE organization_id = master_organization_id;
76: /*Retrieves all Master Items that have Categories of Master controlled Category Sets associated*/
77: CURSOR items_list(master_org_id NUMBER) IS
78: SELECT inventory_item_id,

Line 93: mtl_parameters mp

89: CURSOR child_orgs(item_id NUMBER,
90: master_org_id NUMBER) IS
91: SELECT msib.organization_id
92: FROM mtl_system_items_b msib,
93: mtl_parameters mp
94: WHERE msib.organization_id = mp.organization_id
95: AND msib.inventory_item_id = item_id
96: AND mp.master_organization_id = master_org_id
97: AND mp.organization_id <> mp.master_organization_id;

Line 109: FROM mtl_parameters m

105: /*Case 1 and 2: This will delete additional category records from the child organization
106: that are not present in the Master Organization*/
107: DELETE FROM mtl_item_categories a
108: WHERE a.organization_id IN (SELECT m.organization_id
109: FROM mtl_parameters m
110: WHERE m.master_organization_id = rec_cur.master_organization_id
111: AND m.organization_id <> m.master_organization_id)
112: AND EXISTS (SELECT 'X'
113: FROM mtl_category_sets_b