APPS.INV_GENEALOGY_REPORT_GEN dependencies on MTL_PARAMETERS

Line 513: FROM mtl_parameters mp

509: l_org_desc VARCHAR2(240);
510: Cursor get_organization is
511: SELECT mp.organization_id
512: , hou.NAME
513: FROM mtl_parameters mp
514: , hr_organization_units hou
515: WHERE mp.organization_code = p_organization_code
516: AND hou.organization_id = mp.organization_id;
517:

Line 684: FROM mtl_parameters mp

680: , mln.organization_id
681: INTO l_current_org_code
682: , l_current_org_desc
683: , l_current_org_id
684: FROM mtl_parameters mp
685: , hr_organization_units hou
686: , mtl_lot_numbers mln
687: WHERE mln.gen_object_id = l_object_id
688: AND mp.organization_id = mln.organization_id

Line 697: FROM mtl_parameters mp

693: , msn.current_organization_id
694: INTO l_current_org_code
695: , l_current_org_desc
696: , l_current_org_id
697: FROM mtl_parameters mp
698: , hr_organization_units hou
699: , mtl_serial_numbers msn
700: WHERE msn.gen_object_id = l_object_id
701: AND mp.organization_id = msn.current_organization_id

Line 1987: FROM mtl_parameters mp

1983: ;
1984:
1985: Cursor get_org is
1986: SELECT mp.organization_code
1987: FROM mtl_parameters mp
1988: WHERE mp.organization_id = p_quality_samples_rec.current_org_id
1989: ;
1990:
1991: Cursor get_samples_parent is

Line 3069: From mtl_parameters

3065: and wip.entity_type in (9, 10)
3066: and wip.wip_entity_id = gme.batch_id;
3067: Cursor is_org_process_enabled IS
3068: Select 1
3069: From mtl_parameters
3070: Where organization_id = g_organization_id
3071: and process_enabled_flag= 'Y';
3072: BEGIN
3073: if( p_object_type = 5) then