DBA Data[Home] [Help]

APPS.OKE_AMG_GRP dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 316: Select 'x' from org_organization_definitions

312: and sysdate >= nvl (b.start_date_active, sysdate)
313: and sysdate <= nvl (b.end_date_active, sysdate);
314:
315: Cursor c_check_rec_org IS
316: Select 'x' from org_organization_definitions
317: where nvl(inventory_enabled_flag, 'N') = 'Y'
318: and nvl(disable_date, sysdate) >= sysdate
319: and organization_id= p_ship_to_org_id;
320:

Line 377: Select 'x' from org_organization_definitions

373: and b.deliverable_id=p_deliverable_id
374: and v.designator = p_demand_schedule;
375:
376: Cursor c_check_ship_from IS
377: Select 'x' from org_organization_definitions
378: where nvl(inventory_enabled_flag, 'N') = 'Y'
379: and nvl(disable_date, sysdate) >= sysdate
380: and organization_id= p_ship_from_org_id;
381: