APPS.INVPPRCI dependencies on MTL_ITEM_SUB_INVENTORIES

Line 1228: /* Copy substitute inventories into MTL_ITEM_SUB_INVENTORIES */

1224: and rii.relationship_type_id is not NULL
1225: and rii.reciprocal_flag is not NULL)
1226: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
1227:
1228: /* Copy substitute inventories into MTL_ITEM_SUB_INVENTORIES */
1229: table_name := 'MTL_ITEM_SUB_INVENTORIES';
1230: insert into mtl_item_sub_inventories
1231: (
1232: INVENTORY_ITEM_ID,

Line 1229: table_name := 'MTL_ITEM_SUB_INVENTORIES';

1225: and rii.reciprocal_flag is not NULL)
1226: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
1227:
1228: /* Copy substitute inventories into MTL_ITEM_SUB_INVENTORIES */
1229: table_name := 'MTL_ITEM_SUB_INVENTORIES';
1230: insert into mtl_item_sub_inventories
1231: (
1232: INVENTORY_ITEM_ID,
1233: ORGANIZATION_ID,

Line 1230: insert into mtl_item_sub_inventories

1226: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
1227:
1228: /* Copy substitute inventories into MTL_ITEM_SUB_INVENTORIES */
1229: table_name := 'MTL_ITEM_SUB_INVENTORIES';
1230: insert into mtl_item_sub_inventories
1231: (
1232: INVENTORY_ITEM_ID,
1233: ORGANIZATION_ID,
1234: SECONDARY_INVENTORY,

Line 1323: insert into mtl_item_sub_inventories

1319: and isii.secondary_inventory is not NULL
1320: and isii.inventory_planning_code is not NULL
1321: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
1322:
1323: insert into mtl_item_sub_inventories
1324: (
1325: INVENTORY_ITEM_ID,
1326: ORGANIZATION_ID,
1327: SECONDARY_INVENTORY,

Line 1408: mtl_item_sub_inventories isi,

1404: prg_id, /* program_id */
1405: SYSDATE, /* program_update_date */
1406: isi.ENCUMBRANCE_ACCOUNT
1407: from
1408: mtl_item_sub_inventories isi,
1409: mtl_system_items_interface si
1410: where si.organization_id = isi.organization_id
1411: and si.copy_item_id = isi.inventory_item_id
1412: and not exists ( select NULL