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 749: INSERT INTO mtl_system_items_interface

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

Line 814: FROM mtl_system_items_interface

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

Line 860: UPDATE mtl_system_items_interface set

856:
857: -- ===========================================================
858: -- Set value of product_family_item_id as NULL
859: -- ===========================================================
860: UPDATE mtl_system_items_interface set
861: product_family_item_id = NULL
862: WHERE set_process_id = l_set_process_id;
863:
864:

Line 907: ,mtl_system_items_interface msi

903: ,FND_GLOBAL.prog_appl_id
904: ,FND_GLOBAL.conc_program_id
905: ,SYSDATE
906: FROM mtl_item_revisions_b mir
907: ,mtl_system_items_interface msi
908: WHERE mir.inventory_item_id = msi.inventory_item_id
909: and mir.organization_id = p_source_org_id
910: and msi.organization_id = p_target_org_id
911: and msi.set_process_id = l_set_process_id

Line 988: ,mtl_system_items_interface msi

984: ,FND_GLOBAL.prog_appl_id
985: ,FND_GLOBAL.conc_program_id
986: ,SYSDATE
987: FROM mtl_category_sets_b mcs
988: ,mtl_system_items_interface msi
989: ,mtl_item_categories mic
990: WHERE msi.inventory_item_id = mic.inventory_item_id
991: AND msi.organization_id = p_target_org_id
992: AND mic.organization_id = p_source_org_id