APPS.QA_PLAN_ELEMENT_API dependencies on MTL_PARAMETERS

Line 3486: csi_item_instances cii, mtl_system_items_b msib, mtl_parameters mp

3482:
3483: sql_string := 'SELECT
3484: cii.instance_number, cii.instance_description
3485: FROM
3486: csi_item_instances cii, mtl_system_items_b msib, mtl_parameters mp
3487: WHERE
3488: msib.organization_id = mp.organization_id and
3489: msib.organization_id = cii.last_vld_organization_id and
3490: msib.inventory_item_id = cii.inventory_item_id and

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

3531:
3532: sql_string := 'SELECT
3533: distinct msn.serial_number, msn.descriptive_text
3534: FROM
3535: mtl_serial_numbers msn, csi_item_instances cii, mtl_system_items_b msib, mtl_parameters mp
3536: WHERE
3537: msib.organization_id = mp.organization_id and
3538: msib.organization_id = cii.last_vld_organization_id and
3539: msib.inventory_item_id = cii.inventory_item_id and

Line 4789: from mtl_system_items_b_kfv msikfv, mtl_parameters mp

4785: wild := value;
4786:
4787: --dgupta: Start R12 EAM Integration. Bug 4345492
4788: sql_string := 'select distinct msikfv.concatenated_segments, msikfv.description
4789: from mtl_system_items_b_kfv msikfv, mtl_parameters mp
4790: where msikfv.organization_id = mp.organization_id
4791: and msikfv.eam_item_type in (1,3)
4792: and mp.maint_organization_id = :1
4793: and msikfv.concatenated_segments like :2

Line 5207: FROM mtl_system_items_b_kfv msikfv, mtl_parameters mp

5203: id NUMBER;
5204: --rownum=1 =>better performance since all rows have same inventory_item_id
5205: CURSOR c (o_id NUMBER, a_group VARCHAR2) IS
5206: SELECT msikfv.inventory_item_id
5207: FROM mtl_system_items_b_kfv msikfv, mtl_parameters mp
5208: WHERE msikfv.organization_id = mp.organization_id
5209: and msikfv.eam_item_type in (1,3)
5210: and mp.maint_organization_id = o_id
5211: and msikfv.concatenated_segments = a_group

Line 5607: FROM mtl_parameters

5603:
5604: CURSOR locator is
5605: SELECT stock_locator_control_code,
5606: negative_inv_receipt_code
5607: FROM mtl_parameters
5608: WHERE organization_id = org_id;
5609:
5610: x_org_loc_control NUMBER;
5611: x_neg_inv NUMBER;