DBA Data[Home] [Help]

APPS.AHL_OSP_SHIPMENT_PUB dependencies on MO_GLOBAL

Line 1611: AND def.operating_unit = MO_GLOBAL.get_current_org_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()
1612: AND org.name = p_name;
1613:
1614: CURSOR ahl_sold_to_orgs_csr(p_cust_number IN VARCHAR2) IS
1615: SELECT organization_id

Line 1686: l_org_id := MO_GLOBAL.get_current_org_id();

1682:
1683: ELSE
1684:
1685: -- Changed by jaramana on Sep 9, 2005 for MOAC Uptake
1686: l_org_id := MO_GLOBAL.get_current_org_id();
1687:
1688: --Convert our rec type into OE_ORDER_PUB entities
1689:
1690: x_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;

Line 3908: AND def.operating_unit = MO_GLOBAL.get_current_org_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()
3909: AND org.name = p_name;
3910:
3911: CURSOR ahl_oe_lot_serial_id (p_oe_line_id IN NUMBER) IS
3912: SELECT lot_serial_id