eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_PLANNED_ORDERS dependencies on MTL_SYSTEM_ITEMS

Line 74: FROM mtl_system_items c,

70: c.list_price_per_unit unit_price,
71: c.planner_code planner,
72: build_in_wip_flag build_in_wip,
73: pick_components_flag pick_components
74: FROM mtl_system_items c,
75: mtl_parameters p
76: WHERE c.inventory_item_id = p_inventory_item_id
77: AND c.organization_id = p.organization_id
78: AND p.organization_id = p_organization_id;

Line 86: FROM mtl_system_items_b

82:
83: CURSOR uom_code_cur(t_organization_id NUMBER,
84: t_item_id NUMBER) IS
85: SELECT primary_uom_code
86: FROM mtl_system_items_b
87: WHERE organization_id = t_organization_id
88: AND inventory_item_id = t_item_id;
89:
90: CURSOR C_supplier (p_organization_id NUMBER,l_supplied_item_id NUMBER)

Line 248: FROM mtl_system_items_b

244:
245: Begin
246: SELECT repair_program
247: INTO l_repair_program
248: FROM mtl_system_items_b
249: WHERE organization_id = l_repair_supplier_org_id
250: AND inventory_item_id = p_inventory_item_id;
251: Exception
252: When no_data_found then