APPS.CSP_SCH_INT_PVT dependencies on MTL_RESERVATIONS

Line 383: mtl_reservations mr

379: csp_requirement_lines l,
380: csp_req_line_details dio,
381: csp_req_line_details dres,
382: oe_order_lines_all oola,
383: mtl_reservations mr
384: WHERE h.task_id = p_task_id
385: AND h.task_assignment_id = r_asgn.task_assignment_id
386: AND h.address_type IN ('R', 'S')
387: AND h.requirement_header_id = l.requirement_header_id

Line 441: mtl_reservations mr

437: csp_requirement_lines l,
438: csp_req_line_details dio,
439: csp_req_line_details dres,
440: oe_order_lines_all oola,
441: mtl_reservations mr
442: WHERE h.task_id = p_task_id
443: AND h.task_assignment_id = r_asgn.task_assignment_id
444: AND h.address_type IN ('T', 'C', 'P')
445: AND h.requirement_header_id = l.requirement_header_id

Line 474: mtl_reservations mr

470: csp_req_line_details dio,
471: csp_req_line_details dres,
472: csp_req_line_details dother,
473: oe_order_lines_all oola,
474: mtl_reservations mr
475: WHERE h.task_id = p_task_id
476: AND h.task_assignment_id = r_asgn.task_assignment_id
477: AND h.address_type IN ('T', 'C', 'P')
478: AND h.requirement_header_id = l.requirement_header_id

Line 529: mtl_reservations mr

525: csp_requirement_lines l,
526: csp_req_line_details dio,
527: csp_req_line_details dres,
528: oe_order_lines_all oola,
529: mtl_reservations mr
530: WHERE h.task_id = p_task_id
531: AND h.task_assignment_id = r_asgn.task_assignment_id
532: AND h.address_type IN ('T', 'C', 'P')
533: AND h.requirement_header_id = l.requirement_header_id

Line 583: mtl_reservations mr

579: csp_requirement_lines l,
580: csp_req_line_details dio,
581: csp_req_line_details dres,
582: oe_order_lines_all oola,
583: mtl_reservations mr
584: WHERE h.task_id = p_task_id
585: AND h.task_assignment_id = r_asgn.task_assignment_id
586: AND h.address_type IN ('T', 'C', 'P')
587: AND h.requirement_header_id = l.requirement_header_id

Line 1397: mtl_reservations mr

1393: csp_requirement_lines l,
1394: csp_req_line_details dio,
1395: csp_req_line_details dres,
1396: oe_order_lines_all oola,
1397: mtl_reservations mr
1398: WHERE h.task_id = p_task_id
1399: AND h.task_assignment_id = r_asgn.task_assignment_id
1400: AND h.address_type IN ('T', 'C', 'P')
1401: AND h.requirement_header_id = l.requirement_header_id

Line 2503: mtl_reservations mr

2499: csp_requirement_lines l,
2500: csp_req_line_details dio,
2501: csp_req_line_details dres,
2502: oe_order_lines_all oola,
2503: mtl_reservations mr
2504: WHERE h.task_assignment_id = p_task_assignment_id
2505: AND h.address_type IN ('T', 'C', 'P')
2506: AND h.requirement_header_id = l.requirement_header_id
2507: AND l.requirement_line_id = dio.requirement_line_id

Line 8371: mtl_reservations mr

8367: csp_requirement_lines l,
8368: csp_req_line_details dio,
8369: csp_req_line_details dres,
8370: oe_order_lines_all oola,
8371: mtl_reservations mr
8372: WHERE h.task_id = p_task_id
8373: AND h.task_assignment_id = p_task_asgn_id
8374: AND h.address_type IN ('T', 'C', 'P')
8375: AND h.requirement_header_id = l.requirement_header_id