APPS.INVPVALI dependencies on MTL_SYSTEM_ITEMS_B

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 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