APPS.INVPVALI dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 47: from mtl_system_items_interface mi

43: from mtl_system_items m
44: where m.organization_id = i.organization_id
45: and m.inventory_item_id = i.inventory_item_id)
46: and not exists (select 'X'
47: from mtl_system_items_interface mi
48: where mi.organization_id = i.organization_id
49: and mi.inventory_item_id = i.inventory_item_id
50: and process_flag = 4);
51:

Line 192: FROM mtl_system_items_interface mi

188: ,mi.lifecycle_id
189: ,mi.current_phase_id
190: ,'U'
191: ,mi.transaction_type
192: FROM mtl_system_items_interface mi
193: WHERE mi.organization_id = cp_org_id
194: AND mi.inventory_item_id = cp_item_id
195: AND mi.process_flag = 4
196: UNION

Line 261: l_item_trans_type mtl_system_items_interface.transaction_type%TYPE := NULL;

257: l_revision_id mtl_item_revisions_interface.revision_id%TYPE;
258: l_revid_error BOOLEAN := FALSE;
259:
260: l_item_approved mtl_system_items_b.approval_status%TYPE := NULL;
261: l_item_trans_type mtl_system_items_interface.transaction_type%TYPE := NULL;
262:
263: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
264: l_process_control VARCHAR2(2000) := NULL; --Used by EGO API only for internal flow control
265: l_is_gdsn_batch NUMBER;

Line 514: UPDATE mtl_system_items_interface

510:
511: IF cr.transaction_type ='CREATE'
512: AND l_default_rev = cr.revision THEN
513:
514: UPDATE mtl_system_items_interface
515: SET process_flag = l_process_flag_3
516: WHERE inventory_item_id = cr.inventory_item_id
517: AND organization_id = cr.organization_id
518: AND set_process_id = xset_id;

Line 790: UPDATE mtl_system_items_interface

786:
787: IF cr.transaction_type ='CREATE'
788: AND l_default_rev = cr.revision THEN
789:
790: UPDATE mtl_system_items_interface
791: SET process_flag = l_process_flag_3
792: WHERE inventory_item_id = cr.inventory_item_id
793: AND organization_id = cr.organization_id
794: AND set_process_id = xset_id;

Line 1066: UPDATE mtl_system_items_interface

1062: FETCH c_get_default_rev INTO l_default_rev;
1063: CLOSE c_get_default_rev;
1064:
1065: IF l_default_rev = cr.revision THEN
1066: UPDATE mtl_system_items_interface
1067: SET process_flag = l_process_flag_3
1068: WHERE inventory_item_id = cr.inventory_item_id
1069: AND organization_id = cr.organization_id
1070: AND set_process_id = xset_id;