APPS.PJM_PROJECT_LOCATOR dependencies on MTL_ITEM_LOCATIONS

Line 234: 'FROM mtl_item_locations l1 ' ||

230: 'l2.subinventory_code, ' ||
231: 'DECODE(l1.subinventory_code, ' ||
232: 'l2.subinventory_code, 1, ' ||
233: 'NULL, NULL, 0) ' ||
234: 'FROM mtl_item_locations l1 ' ||
235: ', mtl_item_locations l2 ' ||
236: 'WHERE l1.organization_id = :org_id ' ||
237: 'AND l2.organization_id = l1.organization_id ' ||
238: 'AND l1.inventory_location_id = :locator_id ';

Line 235: ', mtl_item_locations l2 ' ||

231: 'DECODE(l1.subinventory_code, ' ||
232: 'l2.subinventory_code, 1, ' ||
233: 'NULL, NULL, 0) ' ||
234: 'FROM mtl_item_locations l1 ' ||
235: ', mtl_item_locations l2 ' ||
236: 'WHERE l1.organization_id = :org_id ' ||
237: 'AND l2.organization_id = l1.organization_id ' ||
238: 'AND l1.inventory_location_id = :locator_id ';
239:

Line 391: select mtl_item_locations_s.nextval

387: raise subinv_mismatch;
388: end if;
389:
390: if (L_locator_id = -1 and X_create_locator) then
391: select mtl_item_locations_s.nextval
392: into L_locator_id
393: from dual;
394:
395: L_user_id := fnd_profile.value('USER_ID');

Line 397: insert into mtl_item_locations

393: from dual;
394:
395: L_user_id := fnd_profile.value('USER_ID');
396:
397: insert into mtl_item_locations
398: ( last_update_date
399: , last_updated_by
400: , creation_date
401: , created_by

Line 461: from mtl_item_locations

457: , decode(X_project_id,
458: NULL, L_locator_id,
459: nvl(physical_location_id,inventory_location_id)
460: )
461: from mtl_item_locations
462: where organization_id = X_organization_id
463: and inventory_location_id = X_locator_id;
464:
465: --

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

472: --
473: -- 05.16.2002
474: --
475: -- The following SQL has been modified slightly to account for
476: -- cases when subinventory code is NULL on mtl_item_locations.
477: --
478: select nvl(msi.locator_type , 0)
479: into L_locator_ctrl
480: from mtl_secondary_inventories msi

Line 481: , mtl_item_locations mil

477: --
478: select nvl(msi.locator_type , 0)
479: into L_locator_ctrl
480: from mtl_secondary_inventories msi
481: , mtl_item_locations mil
482: where mil.organization_id = X_organization_id
483: and mil.inventory_location_id = X_locator_id
484: and msi.organization_id (+) = mil.organization_id
485: and msi.secondary_inventory_name (+) = mil.subinventory_code;

Line 565: from mtl_item_locations

561: , physical_location_id
562: into L_project_id
563: , L_task_id
564: , L_phy_loc_id
565: from mtl_item_locations
566: where organization_id = X_organization_id
567: and inventory_location_id = X_locator_id;
568:
569: if (L_phy_loc_id is not null) then

Line 586: update mtl_item_locations

582: return FALSE;
583: end if;
584: end if;
585:
586: update mtl_item_locations
587: set physical_location_id = L_phy_loc_id
588: where organization_id = X_organization_id
589: and inventory_location_id = X_locator_id;
590:

Line 870: FROM mtl_item_locations

866:
867: CURSOR C_Loc_Attrib(loc_id NUMBER, org_id NUMBER) IS
868: SELECT project_id,
869: task_id
870: FROM mtl_item_locations
871: WHERE inventory_location_id = loc_id
872: AND organization_id = org_id;
873:
874: CURSOR C_Proj (p_id NUMBER) IS

Line 1293: -- task reference in segment20 into mtl_item_locations

1289: -- Function : This procedure matches a project locator based on
1290: -- the parameters organization_id, locator_id, project_id
1291: -- and task_id. If no locator is found, a new locator is
1292: -- created with project reference in segment19 and
1293: -- task reference in segment20 into mtl_item_locations
1294: -- using same physical attributes (from segment1 upto
1295: -- segment18 depending locator flexfield setup).
1296: --
1297: --

Line 1324: from mtl_item_locations

1320: ) IS
1321: CURSOR C3(v_loc_id NUMBER, v_org_id NUMBER,
1322: v_project_id NUMBER, v_task_id NUMBER)IS
1323: SELECT rowid
1324: from mtl_item_locations
1325: where inventory_location_id = v_loc_id
1326: and organization_id = v_org_id
1327: and nvl(project_id, -1) = nvl(v_project_id, -1)
1328: and nvl(task_id, -1) = nvl(v_task_id, -1);

Line 1333: FROM mtl_item_locations

1329:
1330:
1331: CURSOR C4 (v_loc_id NUMBER, v_org_id NUMBER) IS
1332: SELECT physical_location_id
1333: FROM mtl_item_locations
1334: WHERE inventory_location_id = v_loc_id
1335: and organization_id = v_org_id;
1336:
1337: l_rowid VARCHAR2(400);

Line 1661: from mtl_item_locations

1657: begin
1658: update mtl_transactions_interface
1659: set(locator_id, project_id, task_id) =
1660: (select inventory_location_id, project_id, task_id
1661: from mtl_item_locations
1662: where inventory_location_id = l_supply_loc_id
1663: and organization_id = p_organization_id)
1664: where rowid = l_row_id;
1665: