APPS.INV_DIAG_ITEM dependencies on MTL_SYSTEM_ITEMS_B

Line 39: FROM mtl_system_items_b

35: l_resp fnd_responsibility_tl.Responsibility_Name%type :='Inventory';
36:
37: CURSOR c_item_valid (cp_n_item_id IN NUMBER, cp_n_org_id IN NUMBER) IS
38: SELECT count(*)
39: FROM mtl_system_items_b
40: WHERE organization_id = cp_n_org_id
41: AND inventory_item_id = cp_n_item_id;
42:
43: CURSOR c_item_info (cp_n_item_id IN NUMBER, cp_n_org_id IN NUMBER) IS

Line 45: FROM mtl_system_items_b

41: AND inventory_item_id = cp_n_item_id;
42:
43: CURSOR c_item_info (cp_n_item_id IN NUMBER, cp_n_org_id IN NUMBER) IS
44: SELECT *
45: FROM mtl_system_items_b
46: WHERE organization_id = cp_n_org_id
47: AND inventory_item_id = cp_n_item_id;
48:
49: l_item c_item_info%ROWTYPE;

Line 139: ' FROM mtl_system_items_b '||

135: ',mtl_parameters mpm '||
136: 'WHERE mp.cost_organization_id=mpc.organization_id '||
137: 'AND mp.master_organization_id=mpm.organization_id '||
138: 'AND mp.organization_id IN (SELECT organization_id '||
139: ' FROM mtl_system_items_b '||
140: ' WHERE inventory_item_id='||l_item_id||' )';
141:
142: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Inventory organization information ');
143: sqltxt :='SELECT user_group_name "Group" '||

Line 254: ' FROM mtl_system_items_b msi ' ||

250: ' , micgv.description "Description" ' ||
251: ' , TO_CHAR( micgv.start_date_active, ''DD-MON-RR'' ) "Start Date Active" ' ||
252: ' , TO_CHAR( micgv.end_date_active, ''DD-MON-RR'' ) "End Date Active" ' ||
253: ' , TO_CHAR( micgv.inactive_date, ''DD-MON-RR'' ) "Inactive Date" ' ||
254: ' FROM mtl_system_items_b msi ' ||
255: ' , mtl_item_catalog_groups_kfv micgv ' ||
256: ' WHERE msi.organization_id ='|| l_org_id ||
257: ' AND inventory_item_id = '|| l_item_id ||
258: ' AND msi.item_catalog_group_id = micgv.item_catalog_group_id ' ||

Line 271: ' , mtl_system_items_b msi ' ||

267: ' , mde.required_element_flag "Required" ' ||
268: ' , mde.default_element_flag "Defaulted" ' ||
269: ' FROM mtl_descriptive_elements mde ' ||
270: ' , mtl_descr_element_values mdev ' ||
271: ' , mtl_system_items_b msi ' ||
272: ' WHERE msi.organization_id = '|| l_org_id ||
273: ' AND msi.inventory_item_id = '|| l_item_id ||
274: ' AND msi.inventory_item_id = mdev.inventory_item_id ' ||
275: ' AND mde.item_catalog_group_id = msi.item_catalog_group_id ' ||