APPS.QA_PLAN_ELEMENT_API dependencies on MTL_MATERIAL_STATUSES

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

Line 4166: FROM mtl_material_statuses

4162: id NUMBER;
4163:
4164: CURSOR c (code VARCHAR2) IS
4165: SELECT status_id
4166: FROM mtl_material_statuses
4167: WHERE status_code = code;
4168:
4169: BEGIN
4170:

Line 4207: FROM mtl_serial_numbers msn, mtl_material_statuses mms

4203:
4204: x_item_id := qa_flex_util.get_item_id(x_org_id, x_item_name);
4205:
4206: sql_string := 'SELECT mms.status_code, mms.description
4207: FROM mtl_serial_numbers msn, mtl_material_statuses mms
4208: WHERE msn.inventory_item_id = :1
4209: AND msn.serial_number like :2
4210: AND msn.status_id = mms.status_id
4211: AND mms.status_code like :3

Line 4419: FROM mtl_material_statuses

4415: id NUMBER;
4416:
4417: CURSOR c (code VARCHAR2) IS
4418: SELECT status_id
4419: FROM mtl_material_statuses
4420: WHERE status_code = code;
4421:
4422: BEGIN
4423: