DBA Data[Home] [Help]

APPS.MRP_CRP_HORIZONTAL_PLAN dependencies on CRP_RESOURCE_PLAN

Line 701: crp_resource_plan crp,

697: decode(crp.resource_end_date,
698: NULL, crp.resource_hours,
699: crp.daily_resource_hours)
700: FROM
701: crp_resource_plan crp,
702: crp_planned_resources cpr,
703: mrp_form_query list
704: WHERE
705: cpr.owning_department_id = list.number2

Line 768: FROM crp_resource_plan crp,

764: M_REPETITIVE, REPETITIVE),
765: trunc(crp.resource_date),
766: to_date(NULL),
767: crp.load_rate
768: FROM crp_resource_plan crp,
769: mrp_form_query list
770: WHERE crp.supply_type in (M_PLANNED_ORDER, M_REPETITIVE)
771: AND crp.designator = g_designator
772: AND crp.resource_date < g_cutoff_date