[Home] [Help]
143: bom_calendar_dates order_date,
144: mrp_recommendations recom,
145: mrp_system_items items,
146: mrp_planned_resource_reqs routing,
147: mtl_parameters org,
148: mrp_form_query list
149: WHERE res_start.exception_set_id = org.calendar_exception_set_id
150: AND res_start.calendar_code = org.calendar_code
151: AND res_start.seq_num = order_date.prior_seq_num -
255: muc1.conversion_rate, 0))
256: FROM bom_calendar_dates res_start,
257: bom_calendar_dates order_date,
258: mtl_system_items items,
259: mtl_parameters param,
260: wip_flow_schedules fs,
261: bom_operational_routings routing,
262: bom_operation_sequences seqs,
263: bom_operation_resources res,
520: NVL(dept_res.efficiency, 1.0) ))
521: FROM bom_shift_times shifts,
522: bom_resource_shifts res_shifts,
523: bom_department_resources dept_res,
524: mtl_parameters param,
525: bom_calendar_dates cal,
526: mrp_form_query list
527: WHERE (shifts.calendar_code is NULL OR
528: shifts.calendar_code = param.calendar_code)
581: NVL(brc.to_time, 1)) - NVL(brc.from_TIME, 0)))/3600
582: FROM bom_calendar_dates dates,
583: bom_resource_changes brc,
584: mrp_plan_organizations_v orgs,
585: mtl_parameters param,
586: mrp_form_query list
587: WHERE dates.exception_set_id = param.calendar_exception_set_id
588: AND dates.calendar_code = param.calendar_code
589: AND (brc.action_type = ADD_WORK_DAY
646: FROM bom_shift_times shifts,
647: bom_resource_changes brc,
648: bom_department_resources dept_res,
649: mrp_plan_organizations_v orgs,
650: mtl_parameters param,
651: mrp_form_query list
652: WHERE shifts.calendar_code = param.calendar_code
653: AND shifts.shift_num = brc.shift_num
654: AND TRUNC(brc.from_date) < g_cutoff_date
886: -- --------------------------
887: g_error_stmt := 'Debug - initialize - 20';
888: SELECT calendar_code, calendar_exception_set_id
889: INTO g_calendar_code, g_exc_set_id
890: FROM mtl_parameters
891: WHERE organization_id = g_planned_org;
892:
893: -- -------------------------------
894: -- initialize plan_start_date
1044: DISCRETE_JOBS,REPETITIVE)) THEN
1045: SELECT NVL(cst.item_cost, 0)
1046: INTO v_res_cost
1047: FROM cst_item_costs cst,
1048: mtl_parameters org
1049: WHERE cst.cost_type_id(+) = org.primary_cost_method
1050: AND cst.organization_id(+) = org.cost_organization_id
1051: AND cst.inventory_item_id(+) = activity_rec.assembly_item_id
1052: AND org.organization_id = activity_rec.org_id;
1088: g_planned_org := activity_rec.org_id;
1089:
1090: SELECT calendar_code, calendar_exception_set_id
1091: INTO g_calendar_code, g_exc_set_id
1092: FROM mtl_parameters
1093: WHERE organization_id = g_planned_org;
1094:
1095: END IF;
1096:
1589: -- dbms_output.put_line(g_error_stmt);
1590: -- ----------------------------
1591: SELECT calendar_code, calendar_exception_set_id
1592: INTO g_calendar_code, g_exc_set_id
1593: FROM mtl_parameters
1594: WHERE organization_id = activity_rec.org_id;
1595:
1596: END re_initialize;
1597: