APPS.QA_PLAN_ELEMENT_API dependencies on MTL_SERIAL_NUMBERS

Line 2134: FROM mtl_serial_numbers

2130: -- bso Tue Jul 20 15:20:37 PDT 2004
2131: --
2132: CURSOR c IS
2133: SELECT 1
2134: FROM mtl_serial_numbers
2135: WHERE inventory_item_id = x_item_id AND
2136: current_organization_id = x_org_id AND
2137: (x_lot_num IS NULL OR lot_number = x_lot_num) AND
2138: (x_revision IS NULL OR revision = x_revision) AND

Line 2242: FROM mtl_serial_numbers msn,

2238: -- bso Tue Jul 20 15:52:21 PDT 2004
2239: --
2240: CURSOR c IS
2241: SELECT 1
2242: FROM mtl_serial_numbers msn,
2243: mtl_transaction_lots_temp mtlt
2244: WHERE msn.lot_line_mark_id = x_transaction_id
2245: AND mtlt.transaction_temp_id = msn.lot_line_mark_id
2246: AND mtlt.serial_transaction_temp_id = msn.line_mark_id

Line 2252: FROM mtl_serial_numbers msn

2248: AND x_lot_number IS NOT NULL
2249: AND msn.serial_number = x_serial_number
2250: UNION ALL
2251: SELECT 1
2252: FROM mtl_serial_numbers msn
2253: WHERE msn.line_mark_id = x_transaction_id
2254: AND x_lot_number IS NULL
2255: AND msn.serial_number = x_serial_number;
2256:

Line 3365: from mtl_serial_numbers_all_v

3361: -- Sync up the SQL to be the same with forms.
3362: -- bso Tue Jul 20 16:12:06 PDT 2004
3363: --
3364: sql_string := 'select serial_number, current_status_name
3365: from mtl_serial_numbers_all_v
3366: where current_organization_id = :1
3367: and inventory_item_id = :2
3368: and (:3 is null OR lot_number = :4)
3369: and (:5 is null OR revision = :6)

Line 3443: mtl_serial_numbers msn, csi_item_instances cii, mtl_system_items_b msib, mtl_parameters mp

3439:
3440: sql_string := 'SELECT
3441: distinct msn.serial_number, msn.descriptive_text
3442: FROM
3443: mtl_serial_numbers msn, csi_item_instances cii, mtl_system_items_b msib, mtl_parameters mp
3444: WHERE
3445: msib.organization_id = mp.organization_id and
3446: msib.organization_id = cii.last_vld_organization_id and
3447: msib.inventory_item_id = cii.inventory_item_id and

Line 3543: FROM mtl_serial_numbers msn,

3539: -- msn.lot_line_mark_id and vice versa.
3540: -- bso Tue Jul 20 15:52:21 PDT 2004
3541: --
3542: sql_string := 'SELECT msn.serial_number, msn.current_status
3543: FROM mtl_serial_numbers msn,
3544: mtl_transaction_lots_temp mtlt
3545: WHERE msn.lot_line_mark_id = :1
3546: AND mtlt.transaction_temp_id = msn.lot_line_mark_id
3547: AND mtlt.serial_transaction_temp_id = msn.line_mark_id

Line 3553: FROM mtl_serial_numbers msn

3549: AND :3 IS NOT NULL
3550: AND msn.serial_number like :4
3551: UNION ALL
3552: SELECT msn.serial_number, msn.current_status
3553: FROM mtl_serial_numbers msn
3554: WHERE msn.line_mark_id = :5
3555: AND :6 IS NULL
3556: AND msn.serial_number like :7
3557: ORDER BY 1';

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