APPS.CSP_PARTS_REQUIREMENT dependencies on MTL_RESERVATIONS

Line 3074: FROM mtl_reservations

3070: -- otherwise leave it
3071:
3072: SELECT count(*)
3073: into l_res_same_org
3074: FROM mtl_reservations
3075: WHERE reservation_id = l_source_id
3076: AND organization_id = l_dest_org_id
3077: AND subinventory_code = l_dest_subinv;
3078:

Line 3251: mtl_reservations mr

3247: csp_requirement_lines l,
3248: csp_req_line_details dio,
3249: csp_req_line_details dres,
3250: oe_order_lines_all oola,
3251: mtl_reservations mr
3252: WHERE h.task_id = l_task_id
3253: AND h.task_assignment_id = l_Task_Assignment_id
3254: AND h.address_type IN ('R', 'S')
3255: AND h.requirement_header_id = l.requirement_header_id

Line 3308: mtl_reservations mr

3304: csp_requirement_lines l,
3305: csp_req_line_details dio,
3306: csp_req_line_details dres,
3307: oe_order_lines_all oola,
3308: mtl_reservations mr
3309: WHERE h.task_id = l_task_id
3310: AND h.task_assignment_id = l_Task_Assignment_id
3311: AND h.address_type IN ('T', 'C', 'P')
3312: AND h.requirement_header_id = l.requirement_header_id

Line 3340: mtl_reservations mr

3336: csp_req_line_details dio,
3337: csp_req_line_details dres,
3338: csp_req_line_details dother,
3339: oe_order_lines_all oola,
3340: mtl_reservations mr
3341: WHERE h.task_id = l_task_id
3342: AND h.task_assignment_id = l_Task_Assignment_id
3343: AND h.address_type IN ('T', 'C', 'P')
3344: AND h.requirement_header_id = l.requirement_header_id

Line 3394: mtl_reservations mr

3390: csp_requirement_lines l,
3391: csp_req_line_details dio,
3392: csp_req_line_details dres,
3393: oe_order_lines_all oola,
3394: mtl_reservations mr
3395: WHERE h.task_id = l_task_id
3396: AND h.task_assignment_id = l_Task_Assignment_id
3397: AND h.address_type IN ('T', 'C', 'P')
3398: AND h.requirement_header_id = l.requirement_header_id

Line 3447: mtl_reservations mr

3443: csp_requirement_lines l,
3444: csp_req_line_details dio,
3445: csp_req_line_details dres,
3446: oe_order_lines_all oola,
3447: mtl_reservations mr
3448: WHERE h.task_id = l_task_id
3449: AND h.task_assignment_id = l_Task_Assignment_id
3450: AND h.address_type IN ('T', 'C', 'P')
3451: AND h.requirement_header_id = l.requirement_header_id