APPS.PJM_PROJECT_LOCATOR dependencies on MTL_ITEM_LOCATIONS

Line 219: 'FROM mtl_item_locations l1 ' ||

215: 'l2.subinventory_code, ' ||
216: 'DECODE(l1.subinventory_code, ' ||
217: 'l2.subinventory_code, 1, ' ||
218: 'NULL, NULL, 0) ' ||
219: 'FROM mtl_item_locations l1 ' ||
220: ', mtl_item_locations l2 ' ||
221: 'WHERE l1.organization_id = :org_id ' ||
222: 'AND l2.organization_id = l1.organization_id ' ||
223: 'AND l1.inventory_location_id = :locator_id ';

Line 220: ', mtl_item_locations l2 ' ||

216: 'DECODE(l1.subinventory_code, ' ||
217: 'l2.subinventory_code, 1, ' ||
218: 'NULL, NULL, 0) ' ||
219: 'FROM mtl_item_locations l1 ' ||
220: ', mtl_item_locations l2 ' ||
221: 'WHERE l1.organization_id = :org_id ' ||
222: 'AND l2.organization_id = l1.organization_id ' ||
223: 'AND l1.inventory_location_id = :locator_id ';
224:

Line 376: select mtl_item_locations_s.nextval

372: raise subinv_mismatch;
373: end if;
374:
375: if (L_locator_id = -1 and X_create_locator) then
376: select mtl_item_locations_s.nextval
377: into L_locator_id
378: from dual;
379:
380: L_user_id := fnd_profile.value('USER_ID');

Line 382: insert into mtl_item_locations

378: from dual;
379:
380: L_user_id := fnd_profile.value('USER_ID');
381:
382: insert into mtl_item_locations
383: ( last_update_date
384: , last_updated_by
385: , creation_date
386: , created_by

Line 446: from mtl_item_locations

442: , decode(X_project_id,
443: NULL, L_locator_id,
444: nvl(physical_location_id,inventory_location_id)
445: )
446: from mtl_item_locations
447: where organization_id = X_organization_id
448: and inventory_location_id = X_locator_id;
449:
450: --

Line 461: -- cases when subinventory code is NULL on mtl_item_locations.

457: --
458: -- 05.16.2002
459: --
460: -- The following SQL has been modified slightly to account for
461: -- cases when subinventory code is NULL on mtl_item_locations.
462: --
463: select nvl(msi.locator_type , 0)
464: into L_locator_ctrl
465: from mtl_secondary_inventories msi

Line 466: , mtl_item_locations mil

462: --
463: select nvl(msi.locator_type , 0)
464: into L_locator_ctrl
465: from mtl_secondary_inventories msi
466: , mtl_item_locations mil
467: where mil.organization_id = X_organization_id
468: and mil.inventory_location_id = X_locator_id
469: and msi.organization_id (+) = mil.organization_id
470: and msi.secondary_inventory_name (+) = mil.subinventory_code;

Line 550: from mtl_item_locations

546: , physical_location_id
547: into L_project_id
548: , L_task_id
549: , L_phy_loc_id
550: from mtl_item_locations
551: where organization_id = X_organization_id
552: and inventory_location_id = X_locator_id;
553:
554: if (L_phy_loc_id is not null) then

Line 571: update mtl_item_locations

567: return FALSE;
568: end if;
569: end if;
570:
571: update mtl_item_locations
572: set physical_location_id = L_phy_loc_id
573: where organization_id = X_organization_id
574: and inventory_location_id = X_locator_id;
575:

Line 816: FROM mtl_item_locations

812:
813: CURSOR C_Loc_Attrib(loc_id NUMBER, org_id NUMBER) IS
814: SELECT project_id,
815: task_id
816: FROM mtl_item_locations
817: WHERE inventory_location_id = loc_id
818: AND organization_id = org_id;
819:
820: CURSOR C_Proj (p_id NUMBER) IS

Line 1238: -- task reference in segment20 into mtl_item_locations

1234: -- Function : This procedure matches a project locator based on
1235: -- the parameters organization_id, locator_id, project_id
1236: -- and task_id. If no locator is found, a new locator is
1237: -- created with project reference in segment19 and
1238: -- task reference in segment20 into mtl_item_locations
1239: -- using same physical attributes (from segment1 upto
1240: -- segment18 depending locator flexfield setup).
1241: --
1242: --

Line 1269: from mtl_item_locations

1265: ) IS
1266: CURSOR C3(v_loc_id NUMBER, v_org_id NUMBER,
1267: v_project_id NUMBER, v_task_id NUMBER)IS
1268: SELECT rowid
1269: from mtl_item_locations
1270: where inventory_location_id = v_loc_id
1271: and organization_id = v_org_id
1272: and nvl(project_id, -1) = nvl(v_project_id, -1)
1273: and nvl(task_id, -1) = nvl(v_task_id, -1);

Line 1278: FROM mtl_item_locations

1274:
1275:
1276: CURSOR C4 (v_loc_id NUMBER, v_org_id NUMBER) IS
1277: SELECT physical_location_id
1278: FROM mtl_item_locations
1279: WHERE inventory_location_id = v_loc_id
1280: and organization_id = v_org_id;
1281:
1282: l_rowid VARCHAR2(400);

Line 1602: from mtl_item_locations

1598: begin
1599: update mtl_transactions_interface
1600: set(locator_id, project_id, task_id) =
1601: (select inventory_location_id, project_id, task_id
1602: from mtl_item_locations
1603: where inventory_location_id = l_supply_loc_id
1604: and organization_id = p_organization_id)
1605: where rowid = l_row_id;
1606: