DBA Data[Home] [Help]

APPS.AHL_OSP_SHIPMENT_PUB dependencies on OE_SHIP_FROM_ORGS_V

Line 1607: FROM OE_SHIP_FROM_ORGS_V org, inv_organization_info_v def

1603:
1604: --Used inv_organization_info_v instead of org_organization_definitions to fix the Perf Bug #4919255
1605: CURSOR ahl_ship_from_orgs_csr(p_name IN VARCHAR2) IS
1606: SELECT org.organization_id
1607: FROM OE_SHIP_FROM_ORGS_V org, inv_organization_info_v def
1608: WHERE org.organization_id = def.organization_id
1609: -- Changed by jaramana on Sep 9, 2005 for MOAC Uptake
1610: -- AND def.operating_unit = FND_PROFILE.VALUE('DEFAULT_ORG_ID')
1611: AND def.operating_unit = MO_GLOBAL.get_current_org_id()

Line 3904: FROM OE_SHIP_FROM_ORGS_V org, inv_organization_info_v def

3900:
3901: --Used inv_organization_info_v instead of org_organization_definitions to fix the Perf Bug #4919255
3902: CURSOR ahl_ship_from_orgs_csr(p_name IN VARCHAR2) IS
3903: SELECT org.organization_id
3904: FROM OE_SHIP_FROM_ORGS_V org, inv_organization_info_v def
3905: WHERE org.organization_id = def.organization_id
3906: -- Changed by jaramana on Sep 9, 2005 for MOAC Uptake
3907: -- AND def.operating_unit = FND_PROFILE.VALUE('DEFAULT_ORG_ID')
3908: AND def.operating_unit = MO_GLOBAL.get_current_org_id()