DBA Data[Home] [Help]

APPS.MSC_SCE_PUBLISH_PKG dependencies on MSC_DEMANDS

Line 522: msc_demands dem,

518: decode(instr(dem.order_number,'.'), 0 , dem.order_number, substr(dem.order_number,1,instr(dem.order_number,'.')-1 )),--
519: TRIM(decode(instr(dem.order_number,'(',-1,1),0,null,substr(dem.order_number,instr(dem.order_number,'(',-1,1) + 1,instr(dem.order_number,')',-1,1) - instr(dem.order_number,'(',-1,1) -1 ))) --
520: from msc_plan_organizations_v ov,
521: msc_system_items i,
522: msc_demands dem,
523: msc_trading_partners t1,
524: msc_plan_buckets mpb
525: where ov.plan_id = p_plan_id and
526: ov.planned_organization = NVL(p_org_id, ov.planned_organization) and