APPS.CSE_UTIL_PKG dependencies on MTL_SYSTEM_ITEMS

Line 19: FROM mtl_system_items

15: yes_or_no VARCHAR2(2) := 'N';
16: l_err_text VARCHAR2(2000);
17: CURSOR NL_TRACK_CUR(P_Item_Id IN NUMBER) IS
18: SELECT DISTINCT 'Y'
19: FROM mtl_system_items
20: WHERE inventory_item_id = p_item_id
21: AND organization_id =
22: (select organization_id
23: from mtl_system_items

Line 23: from mtl_system_items

19: FROM mtl_system_items
20: WHERE inventory_item_id = p_item_id
21: AND organization_id =
22: (select organization_id
23: from mtl_system_items
24: where inventory_item_id=P_inventory_item_id
25: and rownum =1)
26: AND enabled_flag = 'Y'
27: AND nvl (start_date_active, l_sysdate) <= l_sysdate

Line 59: FROM mtl_system_items

55: l_err_text VARCHAR2(2000);
56: CURSOR Lot_Cur (P_Item_ID IN NUMBER,
57: P_Org_ID IN NUMBER) IS
58: SELECT DISTINCT 'Y'
59: FROM mtl_system_items
60: WHERE inventory_item_id = P_item_id
61: AND organization_id = P_org_id
62: AND enabled_flag = 'Y'
63: AND nvl (start_date_active, l_sysdate) <= l_sysdate

Line 95: FROM mtl_system_items

91: l_err_text VARCHAR2(2000);
92: CURSOR Serial_CUR(P_Item_Id IN NUMBER,
93: P_Org_Id IN NUMBER) IS
94: SELECT DISTINCT 'Y'
95: FROM mtl_system_items
96: WHERE inventory_item_id = p_item_id
97: AND organization_id = p_org_id
98: AND enabled_flag = 'Y'
99: AND nvl (start_date_active, l_sysdate) <= l_sysdate

Line 169: FROM mtl_system_items

165: -- variable_name datatype NOT NULL DEFAULT default_value ;
166: l_err_text VARCHAR2(2000);
167: CURSOR Asset_CC_Cur (P_Item_Id IN NUMBER) IS
168: SELECT DISTINCT asset_creation_code
169: FROM mtl_system_items
170: WHERE inventory_item_id = p_inventory_item_id
171: AND organization_id =
172: (select organization_id
173: from mtl_system_items

Line 173: from mtl_system_items

169: FROM mtl_system_items
170: WHERE inventory_item_id = p_inventory_item_id
171: AND organization_id =
172: (select organization_id
173: from mtl_system_items
174: where inventory_item_id=p_inventory_item_id
175: and rownum=1)
176: AND enabled_flag = 'Y'
177: AND nvl (start_date_active, l_sysdate) <= l_sysdate