APPS.INVPPRCI dependencies on MTL_SECONDARY_LOCATORS

Line 1420: /* Copy secondary locators into MTL_SECONDARY_LOCATORS table */

1416: and isii.secondary_inventory is not NULL
1417: and isii.inventory_planning_code is not NULL)
1418: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
1419:
1420: /* Copy secondary locators into MTL_SECONDARY_LOCATORS table */
1421: table_name := 'MTL_SECONDARY_LOCATORS';
1422: insert into mtl_secondary_locators
1423: (
1424: inventory_item_id,

Line 1421: table_name := 'MTL_SECONDARY_LOCATORS';

1417: and isii.inventory_planning_code is not NULL)
1418: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
1419:
1420: /* Copy secondary locators into MTL_SECONDARY_LOCATORS table */
1421: table_name := 'MTL_SECONDARY_LOCATORS';
1422: insert into mtl_secondary_locators
1423: (
1424: inventory_item_id,
1425: organization_id,

Line 1422: insert into mtl_secondary_locators

1418: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
1419:
1420: /* Copy secondary locators into MTL_SECONDARY_LOCATORS table */
1421: table_name := 'MTL_SECONDARY_LOCATORS';
1422: insert into mtl_secondary_locators
1423: (
1424: inventory_item_id,
1425: organization_id,
1426: secondary_locator,

Line 1465: insert into mtl_secondary_locators

1461: and sli.secondary_locator is not NULL
1462: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
1463:
1464:
1465: insert into mtl_secondary_locators
1466: (
1467: inventory_item_id,
1468: organization_id,
1469: secondary_locator,

Line 1500: mtl_secondary_locators sl,

1496: prg_appid, /* program_application_id */
1497: prg_id, /* program_id */
1498: SYSDATE /* program_update_date */
1499: from
1500: mtl_secondary_locators sl,
1501: mtl_system_items_interface si
1502: where si.organization_id = sl.organization_id
1503: and si.copy_item_id = sl.inventory_item_id
1504: and not exists ( select NULL