DBA Data[Home] [Help]

APPS.AHL_FMP_COMMON_PVT dependencies on INV_ORGANIZATION_INFO_V

Line 1039: from inv_organization_info_v org,

1035: where a.manufacturer_id = b.manufacturer_id
1036: and b.manufacturer_name = c_manufacturer_name
1037: and a.organization_id in ( select distinct
1038: m.master_organization_id
1039: from inv_organization_info_v org,
1040: mtl_parameters m
1041: where org.organization_id = m.organization_id
1042: and nvl(org.operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id() );
1043:

Line 1062: from inv_organization_info_v org,

1058: from mtl_mfg_part_numbers
1059: where manufacturer_id = c_manufacturer_id
1060: and organization_id in ( select distinct
1061: m.master_organization_id
1062: from inv_organization_info_v org,
1063: mtl_parameters m
1064: where org.organization_id = m.organization_id
1065: and nvl(org.operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id() );
1066: