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.QA_PLAN_ELEMENT_API dependencies on MTL_LOT_NUMBERS

Line 2117: FROM mtl_lot_numbers

2113: RETURN BOOLEAN IS
2114:
2115: CURSOR c IS
2116: SELECT 1
2117: FROM mtl_lot_numbers
2118: WHERE inventory_item_id = x_item_id AND
2119: organization_id = x_org_id AND
2120: lot_number = x_lot_num;
2121:

Line 3423: from mtl_lot_numbers

3419:
3420: x_item_id := qa_flex_util.get_item_id(x_org_id, x_item_name);
3421:
3422: sql_string := 'select lot_number, description
3423: from mtl_lot_numbers
3424: where inventory_item_id = :1
3425: and organization_id = :2
3426: and lot_number like :3
3427: and (disable_flag = 2 or disable_flag is null)

Line 4345: FROM mtl_lot_numbers mln, mtl_material_statuses mms

4341: -- Added the organization_id condition in the following select statement.
4342: -- Bug 2686970. suramasw Wed Nov 27 04:45:34 PST 2002.
4343:
4344: sql_string := 'SELECT mms.status_code, mms.description
4345: FROM mtl_lot_numbers mln, mtl_material_statuses mms
4346: WHERE mln.inventory_item_id = :1
4347: AND mln.organization_id = :2
4348: AND mln.lot_number like :3
4349: AND mln.status_id = mms.status_id