DBA Data[Home] [Help]

APPS.AHL_FMP_COMMON_PVT dependencies on INV_ORGANIZATION_INFO_V

Line 1028: from inv_organization_info_v org,

1024: where a.manufacturer_id = b.manufacturer_id
1025: and b.manufacturer_name = c_manufacturer_name
1026: and a.organization_id in ( select distinct
1027: m.master_organization_id
1028: from inv_organization_info_v org,
1029: mtl_parameters m
1030: where org.organization_id = m.organization_id
1031: and nvl(org.operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id() );
1032:

Line 1051: from inv_organization_info_v org,

1047: from mtl_mfg_part_numbers
1048: where manufacturer_id = c_manufacturer_id
1049: and organization_id in ( select distinct
1050: m.master_organization_id
1051: from inv_organization_info_v org,
1052: mtl_parameters m
1053: where org.organization_id = m.organization_id
1054: and nvl(org.operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id() );
1055: