APPS.QA_PLAN_ELEMENT_API dependencies on MTL_MATERIAL_STATUSES

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

Line 4364: FROM mtl_material_statuses

4360: id NUMBER;
4361:
4362: CURSOR c (code VARCHAR2) IS
4363: SELECT status_id
4364: FROM mtl_material_statuses
4365: WHERE status_code = code;
4366:
4367: BEGIN
4368:

Line 4405: FROM mtl_serial_numbers msn, mtl_material_statuses mms

4401:
4402: x_item_id := qa_flex_util.get_item_id(x_org_id, x_item_name);
4403:
4404: sql_string := 'SELECT mms.status_code, mms.description
4405: FROM mtl_serial_numbers msn, mtl_material_statuses mms
4406: WHERE msn.inventory_item_id = :1
4407: AND msn.serial_number like :2
4408: AND msn.status_id = mms.status_id
4409: AND mms.status_code like :3

Line 4617: FROM mtl_material_statuses

4613: id NUMBER;
4614:
4615: CURSOR c (code VARCHAR2) IS
4616: SELECT status_id
4617: FROM mtl_material_statuses
4618: WHERE status_code = code;
4619:
4620: BEGIN
4621: