APPS.INV_DIAG_PI_SUBLOC dependencies on MTL_ITEM_LOCATIONS

Line 40: and not exists (select 1 from mtl_item_locations mil

36: moqd.update_transaction_id
37: from mtl_onhand_quantities_detail moqd
38: where moqd.locator_id is not null
39: and moqd.organization_id = NVL(cp_n_org_id, moqd.organization_id)
40: and not exists (select 1 from mtl_item_locations mil
41: where mil.organization_id = moqd.organization_id
42: and mil.subinventory_code = moqd.subinventory_code
43: and mil.inventory_location_id = moqd.locator_id)
44: and exists (SELECT 1 FROM MTL_PARAMETERS P,

Line 87: ' and not exists (select 1 from mtl_item_locations mil ' ||

83: sqltxt := sqltxt || ' AND moqd.organization_id = ' || l_org_id ;
84: END IF;
85:
86: sqltxt := sqltxt || ' and moqd.inventory_item_id = mif.inventory_item_id(+) ' ||
87: ' and not exists (select 1 from mtl_item_locations mil ' ||
88: ' where mil.organization_id = moqd.organization_id ' ||
89: ' and mil.subinventory_code = moqd.subinventory_code ' ||
90: ' and mil.inventory_location_id = moqd.locator_id) ' ||
91: ' and exists (SELECT 1' ||

Line 153: ' (select 1 from mtl_item_locations mil' ||

149: ' WHERE mpit.physical_inventory_id = mpi.physical_inventory_id' ||
150: ' and mpit.adjustment_id = ' || rec_phy_adj.physical_adjustment_id ||
151: ' AND mpit.inventory_item_id = mif.inventory_item_id(+)' ||
152: ' and mpit.locator_id is not null and not exists' ||
153: ' (select 1 from mtl_item_locations mil' ||
154: ' where mil.organization_id = mpit.organization_id' ||
155: ' and mil.subinventory_code = mpit.subinventory' ||
156: ' and mil.inventory_location_id = mpit.locator_id) ' ||
157: ' ORDER BY mpi.physical_inventory_id ';

Line 197: ' (select 1 from mtl_item_locations mil' ||

193: ' MPA.COST_GROUP_ID' ||
194: ' FROM mtl_physical_adjustments mpa' ||
195: ' WHERE mpa.adjustment_id = ' || rec_phy_adj.physical_adjustment_id ||
196: ' and locator_id is not null and not exists' ||
197: ' (select 1 from mtl_item_locations mil' ||
198: ' where mil.organization_id = mpa.organization_id' ||
199: ' and mil.subinventory_code = mpa.subinventory_name' ||
200: ' and mil.inventory_location_id = mpa.locator_id)' ||
201: ' ORDER BY mpa.physical_inventory_id ' ;