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.OZF_CLAIM_PUB dependencies on MTL_SYSTEM_ITEMS

Line 79: mtl_system_items c

75: -- Fix for Bug 11932210
76: CURSOR c_item_uom(p_item_uom IN VARCHAR2,p_inventory_item_id IN NUMBER,p_org_id IN NUMBER)IS
77: SELECT a.uom_code
78: FROM mtl_units_of_measure a,
79: mtl_system_items c
80: WHERE c.primary_unit_of_measure = a.unit_of_measure
81: AND c.organization_id = p_org_id
82: AND c.inventory_item_id = p_inventory_item_id
83: AND uom_code = p_item_uom;

Line 683: mtl_system_items c

679: -- Fix for Bug 11932210
680: CURSOR c_item_uom(p_item_uom IN VARCHAR2,p_inventory_item_id IN NUMBER,p_org_id IN NUMBER)IS
681: SELECT a.uom_code
682: FROM mtl_units_of_measure a,
683: mtl_system_items c
684: WHERE c.primary_unit_of_measure = a.unit_of_measure
685: AND c.organization_id = p_org_id
686: AND c.inventory_item_id = p_inventory_item_id
687: AND uom_code = p_item_uom;

Line 1133: FROM mtl_system_items_kfv

1129: WHERE claim_line_id = cv_claim_line_id;
1130:
1131: CURSOR c_inventory_item_id(p_inventory_item_id IN NUMBER,p_org_id IN NUMBER)IS
1132: SELECT inventory_item_id,NVL(description,concatenated_segments)
1133: FROM mtl_system_items_kfv
1134: WHERE inventory_item_id = p_inventory_item_id
1135: AND organization_id = p_org_id;
1136:
1137: CURSOR c_category_id(p_category_id IN NUMBER) IS