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 2098: FROM mtl_lot_numbers

2094: RETURN BOOLEAN IS
2095:
2096: CURSOR c IS
2097: SELECT 1
2098: FROM mtl_lot_numbers
2099: WHERE inventory_item_id = x_item_id AND
2100: organization_id = x_org_id AND
2101: lot_number = x_lot_num;
2102:

Line 3331: from mtl_lot_numbers

3327:
3328: x_item_id := qa_flex_util.get_item_id(x_org_id, x_item_name);
3329:
3330: sql_string := 'select lot_number, description
3331: from mtl_lot_numbers
3332: where inventory_item_id = :1
3333: and organization_id = :2
3334: and lot_number like :3
3335: and (disable_flag = 2 or disable_flag is null)

Line 4147: FROM mtl_lot_numbers mln, mtl_material_statuses mms

4143: -- Added the organization_id condition in the following select statement.
4144: -- Bug 2686970. suramasw Wed Nov 27 04:45:34 PST 2002.
4145:
4146: sql_string := 'SELECT mms.status_code, mms.description
4147: FROM mtl_lot_numbers mln, mtl_material_statuses mms
4148: WHERE mln.inventory_item_id = :1
4149: AND mln.organization_id = :2
4150: AND mln.lot_number like :3
4151: AND mln.status_id = mms.status_id