APPS.INVPVALI dependencies on MTL_SYSTEM_ITEMS

Line 43: from mtl_system_items m

39: where i.process_flag = 2
40: and i.set_process_id = xset_id
41: and (i.organization_id = org_id or all_org = 1)
42: and not exists (select 'X'
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

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 94: from mtl_system_items_b m

90: where i.set_process_id = xset_id
91: and i.process_flag = 2
92: and (i.transaction_type = 'UPDATE'
93: or exists (select null
94: from mtl_system_items_b m
95: where m.organization_id = i.organization_id
96: and m.inventory_item_id = i.inventory_item_id));
97: --End: Check for data security and user privileges
98: /*

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 202: FROM mtl_system_items_b m

198: ,m.lifecycle_id
199: ,m.current_phase_id
200: ,NVL(m.approval_status,'A')
201: ,'EXISTS'
202: FROM mtl_system_items_b m
203: WHERE m.organization_id = cp_org_id
204: AND m.inventory_item_id = cp_item_id;
205:
206:

Line 260: l_item_approved mtl_system_items_b.approval_status%TYPE := NULL;

256: --End:3059993:Revision create should honour items phase policy
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

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;