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 515: UPDATE mtl_system_items_interface

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

Line 795: UPDATE mtl_system_items_interface

791:
792: IF cr.transaction_type ='CREATE'
793: AND l_default_rev = cr.revision THEN
794:
795: UPDATE mtl_system_items_interface
796: SET process_flag = l_process_flag_3
797: WHERE inventory_item_id = cr.inventory_item_id
798: AND organization_id = cr.organization_id
799: AND set_process_id = xset_id;

Line 1071: UPDATE mtl_system_items_interface

1067: FETCH c_get_default_rev INTO l_default_rev;
1068: CLOSE c_get_default_rev;
1069:
1070: IF l_default_rev = cr.revision THEN
1071: UPDATE mtl_system_items_interface
1072: SET process_flag = l_process_flag_3
1073: WHERE inventory_item_id = cr.inventory_item_id
1074: AND organization_id = cr.organization_id
1075: AND set_process_id = xset_id;