DBA Data[Home] [Help]

APPS.INV_ITEM_ORG_ASSIGN_CP dependencies on MTL_SYSTEM_ITEMS

Line 599: ' FROM mtl_system_items_b msi' ||

595: );
596: END IF;
597:
598: x_item_cursor := 'SELECT msi.inventory_item_id' ||
599: ' FROM mtl_system_items_b msi' ||
600: l_mcat_f ||
601: ' WHERE msi.organization_id = :b_master_org_id ' ||
602: l_mstk_w ||
603: l_mcat_w1 ||

Line 699: SELECT mtl_system_items_intf_sets_s.NEXTVAL

695: , '> Get_Set_Process_ID'
696: );
697: END IF;
698:
699: SELECT mtl_system_items_intf_sets_s.NEXTVAL
700: INTO l_set_process_id
701: FROM dual;
702:
703: IF G_DEBUG = 'Y' THEN

Line 979: FROM mtl_system_items

975: LOOP
976:
977: SELECT COUNT(*)
978: INTO l_count
979: FROM mtl_system_items
980: WHERE organization_id = p_org_tbl(l_Idx)
981: AND inventory_item_id = p_inventory_item_id;
982:
983: IF l_count = 0 THEN

Line 1027: FROM mtl_system_items_interface

1023: -- from the interface tables
1024: -- Otherwise, that record exists in the interface tables
1025: SELECT COUNT(*)
1026: INTO l_error_count
1027: FROM mtl_system_items_interface
1028: WHERE request_id = FND_GLOBAL.conc_request_id
1029: /*AND process_flag = 4; Bug 5962957 Changing this to 1 since the records are passed in as process_flag 1*/
1030: AND process_flag = 1;
1031:

Line 1347: mtl_system_items_b msib

1343: SELECT
1344: msib.primary_uom_code primary_uom_code
1345: , msib.primary_unit_of_measure primary_unit_of_measure
1346: FROM
1347: mtl_system_items_b msib
1348: , mtl_units_of_measure muom
1349: WHERE msib.organization_id = c_master_org_id
1350: AND msib.inventory_item_id = c_inventory_item_id
1351: AND msib.primary_unit_of_measure = muom.unit_of_measure

Line 1369: mtl_system_items_interface

1365: , organization_id
1366: , transaction_id
1367: , set_process_id
1368: FROM
1369: mtl_system_items_interface
1370: WHERE set_process_id = c_set_process_id
1371: AND inventory_item_id = c_inventory_item_id
1372: AND organization_id = c_organization_id
1373: FOR UPDATE;

Line 1764: INSERT INTO mtl_system_items_interface

1760:
1761:
1762:
1763: FORALL l_Idx IN l_min_index..l_max_index
1764: INSERT INTO mtl_system_items_interface
1765: ( process_flag
1766: , set_process_id
1767: , transaction_type
1768: , inventory_item_id

Line 1903: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

1899: ,l_rev_label
1900: ,l_rev_label
1901: ,SYSDATE
1902: ,SYSDATE
1903: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
1904: ,/*4 Bug 5962957 here the validation should happen so changing it to 1*/ 1
1905: ,'CREATE'
1906: ,l_set_process_id
1907: ,SYSDATE