DBA Data[Home] [Help]

APPS.INV_GENEALOGY_REPORT_GEN dependencies on MTL_PARAMETERS

Line 509: FROM mtl_parameters mp

505: l_org_desc VARCHAR2(240);
506: Cursor get_organization is
507: SELECT mp.organization_id
508: , hou.NAME
509: FROM mtl_parameters mp
510: , hr_organization_units hou
511: WHERE mp.organization_code = p_organization_code
512: AND hou.organization_id = mp.organization_id;
513:

Line 680: FROM mtl_parameters mp

676: , mln.organization_id
677: INTO l_current_org_code
678: , l_current_org_desc
679: , l_current_org_id
680: FROM mtl_parameters mp
681: , hr_organization_units hou
682: , mtl_lot_numbers mln
683: WHERE mln.gen_object_id = l_object_id
684: AND mp.organization_id = mln.organization_id

Line 693: FROM mtl_parameters mp

689: , msn.current_organization_id
690: INTO l_current_org_code
691: , l_current_org_desc
692: , l_current_org_id
693: FROM mtl_parameters mp
694: , hr_organization_units hou
695: , mtl_serial_numbers msn
696: WHERE msn.gen_object_id = l_object_id
697: AND mp.organization_id = msn.current_organization_id

Line 1979: FROM mtl_parameters mp

1975: ;
1976:
1977: Cursor get_org is
1978: SELECT mp.organization_code
1979: FROM mtl_parameters mp
1980: WHERE mp.organization_id = p_quality_samples_rec.current_org_id
1981: ;
1982:
1983: Cursor get_samples_parent is