DBA Data[Home] [Help]

APPS.AHL_OSP_SHIPMENT_PUB dependencies on MO_GLOBAL

Line 1576: AND def.operating_unit = MO_GLOBAL.get_current_org_id()

1572: FROM OE_SHIP_FROM_ORGS_V org, inv_organization_info_v def
1573: WHERE org.organization_id = def.organization_id
1574: -- Changed by jaramana on Sep 9, 2005 for MOAC Uptake
1575: -- AND def.operating_unit = FND_PROFILE.VALUE('DEFAULT_ORG_ID')
1576: AND def.operating_unit = MO_GLOBAL.get_current_org_id()
1577: AND org.name = p_name;
1578:
1579: CURSOR ahl_sold_to_orgs_csr(p_cust_number IN VARCHAR2) IS
1580: SELECT organization_id

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

1647:
1648: ELSE
1649:
1650: -- Changed by jaramana on Sep 9, 2005 for MOAC Uptake
1651: l_org_id := MO_GLOBAL.get_current_org_id();
1652:
1653: --Convert our rec type into OE_ORDER_PUB entities
1654:
1655: x_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;

Line 3924: AND def.operating_unit = MO_GLOBAL.get_current_org_id()

3920: FROM OE_SHIP_FROM_ORGS_V org, inv_organization_info_v def
3921: WHERE org.organization_id = def.organization_id
3922: -- Changed by jaramana on Sep 9, 2005 for MOAC Uptake
3923: -- AND def.operating_unit = FND_PROFILE.VALUE('DEFAULT_ORG_ID')
3924: AND def.operating_unit = MO_GLOBAL.get_current_org_id()
3925: AND org.name = p_name;
3926:
3927: CURSOR ahl_oe_lot_serial_id (p_oe_line_id IN NUMBER) IS
3928: SELECT lot_serial_id