APPS.INV_COPY_ITEM_CP dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 553: l_set_process_id mtl_system_items_interface.set_process_id%TYPE;

549: l_return_code INTEGER;
550: l_counter NUMBER := 1;
551: l_validate_items NUMBER;
552: l_rowid ROWID;
553: l_set_process_id mtl_system_items_interface.set_process_id%TYPE;
554: l_organization_id mtl_parameters.organization_id%TYPE;
555: l_expense_Account mtl_parameters.expense_Account%TYPE;
556: l_sales_account mtl_parameters.sales_account%TYPE;
557: l_cost_of_sales_account mtl_parameters.cost_of_sales_account%TYPE;

Line 751: INSERT INTO mtl_system_items_interface

747:
748: -- ===========================================================
749: -- Insert into Items interface table
750: -- ===========================================================
751: INSERT INTO mtl_system_items_interface
752: ( process_flag
753: , set_process_id
754: , transaction_type
755: , inventory_item_id

Line 816: FROM mtl_system_items_interface

812:
813: -- Get rowid from items interface table
814: SELECT rowid
815: INTO l_rowid
816: FROM mtl_system_items_interface
817: WHERE set_process_id = l_set_process_id
818: AND inventory_item_id = l_mtl_system_items_tbl(l_counter).inventory_item_id
819: AND organization_id = p_target_org_id;
820:

Line 880: UPDATE mtl_system_items_interface set

876:
877: -- ===========================================================
878: -- Set value of product_family_item_id as NULL
879: -- ===========================================================
880: UPDATE mtl_system_items_interface set
881: product_family_item_id = NULL
882: WHERE set_process_id = l_set_process_id;
883:
884:

Line 927: ,mtl_system_items_interface msi

923: ,FND_GLOBAL.prog_appl_id
924: ,FND_GLOBAL.conc_program_id
925: ,SYSDATE
926: FROM mtl_item_revisions_b mir
927: ,mtl_system_items_interface msi
928: WHERE mir.inventory_item_id = msi.inventory_item_id
929: and mir.organization_id = p_source_org_id
930: and msi.organization_id = p_target_org_id
931: and msi.set_process_id = l_set_process_id

Line 1008: ,mtl_system_items_interface msi

1004: ,FND_GLOBAL.prog_appl_id
1005: ,FND_GLOBAL.conc_program_id
1006: ,SYSDATE
1007: FROM mtl_category_sets_b mcs
1008: ,mtl_system_items_interface msi
1009: ,mtl_item_categories mic
1010: WHERE msi.inventory_item_id = mic.inventory_item_id
1011: AND msi.organization_id = p_target_org_id
1012: AND mic.organization_id = p_source_org_id