APPS.QA_PLAN_ELEMENT_API dependencies on MTL_PARAMETERS

Line 3394: csi_item_instances cii, mtl_system_items_b msib, mtl_parameters mp

3390:
3391: sql_string := 'SELECT
3392: cii.instance_number, cii.instance_description
3393: FROM
3394: csi_item_instances cii, mtl_system_items_b msib, mtl_parameters mp
3395: WHERE
3396: msib.organization_id = mp.organization_id and
3397: msib.organization_id = cii.last_vld_organization_id and
3398: msib.inventory_item_id = cii.inventory_item_id and

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 4591: from mtl_system_items_b_kfv msikfv, mtl_parameters mp

4587: wild := value;
4588:
4589: --dgupta: Start R12 EAM Integration. Bug 4345492
4590: sql_string := 'select distinct msikfv.concatenated_segments, msikfv.description
4591: from mtl_system_items_b_kfv msikfv, mtl_parameters mp
4592: where msikfv.organization_id = mp.organization_id
4593: and msikfv.eam_item_type in (1,3)
4594: and mp.maint_organization_id = :1
4595: and msikfv.concatenated_segments like :2

Line 5009: FROM mtl_system_items_b_kfv msikfv, mtl_parameters mp

5005: id NUMBER;
5006: --rownum=1 =>better performance since all rows have same inventory_item_id
5007: CURSOR c (o_id NUMBER, a_group VARCHAR2) IS
5008: SELECT msikfv.inventory_item_id
5009: FROM mtl_system_items_b_kfv msikfv, mtl_parameters mp
5010: WHERE msikfv.organization_id = mp.organization_id
5011: and msikfv.eam_item_type in (1,3)
5012: and mp.maint_organization_id = o_id
5013: and msikfv.concatenated_segments = a_group

Line 5403: FROM mtl_parameters

5399:
5400: CURSOR locator is
5401: SELECT stock_locator_control_code,
5402: negative_inv_receipt_code
5403: FROM mtl_parameters
5404: WHERE organization_id = org_id;
5405:
5406: x_org_loc_control NUMBER;
5407: x_neg_inv NUMBER;