APPS.INVNIRIS dependencies on MTL_SYSTEM_ITEMS_B

Line 24: l_item_approval_status mtl_system_items_b.approval_status%TYPE; --Bug 4418037

20: status NUMBER;
21: l_sysdate DATE ;
22: l_nir_rec_exists BOOLEAN;
23: l_flag_error NUMBER;
24: l_item_approval_status mtl_system_items_b.approval_status%TYPE; --Bug 4418037
25: l_dumm_status NUMBER;
26: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
27: l_err_text VARCHAR2(1000);
28:

Line 98: FROM mtl_system_items_b

94:
95: BEGIN
96: SELECT approval_status
97: INTO l_item_approval_status
98: FROM mtl_system_items_b
99: WHERE inventory_item_id = cur.INVENTORY_ITEM_ID
100: AND organization_id = cur.ORGANIZATION_ID;
101: EXCEPTION
102: WHEN OTHERS THEN

Line 113: FROM mtl_system_items_b msi

109:
110: BEGIN
111: SELECT msi.approval_status
112: INTO l_item_approval_status
113: FROM mtl_system_items_b msi
114: WHERE msi.inventory_item_id = cur.inventory_item_id
115: AND msi.organization_id = (SELECT mp.master_organization_id
116: FROM mtl_parameters mp
117: WHERE mp.organization_id = cur.organization_id);

Line 640: mtl_system_items_b msb

636: ,msb.style_item_flag
637: ,msb.style_item_id
638: ,msb.gdsn_outbound_enabled_flag
639: FROM mtl_system_items_interface msi,
640: mtl_system_items_b msb
641: WHERE msi.process_flag = 1
642: AND msi.set_process_id = xset_id
643: AND ((msi.organization_id = org_id) or (all_org = 1))
644: AND msi.transaction_type = 'UPDATE'

Line 695: l_status_code mtl_system_items_b.inventory_item_status_code%TYPE;

691: l_structure_type_id NUMBER; --5216971
692: l_values_provided BOOLEAN := FALSE;
693: l_desc_status_change BOOLEAN := FALSE;
694: l_rowid ROWID;
695: l_status_code mtl_system_items_b.inventory_item_status_code%TYPE;
696: l_eng_item_flag mtl_system_items_b.eng_item_flag%TYPE;
697:
698: --Bug: 5532737
699: l_attr_grp_name EGO_ATTR_GROUPS_V.ATTR_GROUP_DISP_NAME%TYPE;

Line 696: l_eng_item_flag mtl_system_items_b.eng_item_flag%TYPE;

692: l_values_provided BOOLEAN := FALSE;
693: l_desc_status_change BOOLEAN := FALSE;
694: l_rowid ROWID;
695: l_status_code mtl_system_items_b.inventory_item_status_code%TYPE;
696: l_eng_item_flag mtl_system_items_b.eng_item_flag%TYPE;
697:
698: --Bug: 5532737
699: l_attr_grp_name EGO_ATTR_GROUPS_V.ATTR_GROUP_DISP_NAME%TYPE;
700: l_ch_policy_found BOOLEAN := FALSE;