DBA Data[Home] [Help]

APPS.MSD_STRIPE_DEMAND_PLAN dependencies on MSD_DP_ISO_ORGANIZATIONS

Line 1134: FROM msd_dp_iso_organizations mdio,

1130: fnd_global.user_id,
1131: mlv.system_attribute1,
1132: mlv.system_attribute2,
1133: mlv.dp_enabled_flag
1134: FROM msd_dp_iso_organizations mdio,
1135: msd_level_org_asscns mloa,
1136: msd_level_values mlv
1137: WHERE
1138: mdio.demand_plan_id = p_demand_plan_id

Line 3413: FROM msd_dp_iso_organizations mdio,

3409: IS
3410: SELECT 1
3411: FROM dual
3412: WHERE EXISTS (SELECT mloa.sr_level_pk
3413: FROM msd_dp_iso_organizations mdio,
3414: msd_level_org_asscns mloa
3415: WHERE
3416: mdio.demand_plan_id = p_demand_plan_id
3417: AND mloa.instance = mdio.sr_instance_id

Line 3442: FROM msd_dp_iso_organizations mdio,

3438: demand_plan_id = p_demand_plan_id
3439: AND level_id = 11
3440: MINUS
3441: SELECT mloa.sr_level_pk
3442: FROM msd_dp_iso_organizations mdio,
3443: msd_level_org_asscns mloa
3444: WHERE
3445: mdio.demand_plan_id = p_demand_plan_id
3446: AND mloa.instance = mdio.sr_instance_id