DBA Data[Home] [Help]

APPS.CSF_DEBRIEF_UPDATE_PKG dependencies on MTL_RESERVATIONS

Line 487: mtl_reservations mr

483: SUM(mr.reservation_quantity)
484: FROM csp_requirement_headers crh,
485: csp_requirement_lines crl,
486: csp_req_line_details crld,
487: mtl_reservations mr
488: WHERE crh.task_assignment_id = p_task_assignment_id
489: AND crl.requirement_header_id = crh.requirement_header_id
490: AND crld.requirement_line_id = crl.requirement_line_id
491: AND crld.source_type = 'RES'

Line 1791: mtl_reservations mr

1787: Select crld.source_id,crld.req_line_detail_id,crh.requirement_header_id,mr.reservation_quantity
1788: from csp_requirement_headers crh,
1789: csp_requirement_lines crl,
1790: csp_req_line_details crld,
1791: mtl_reservations mr
1792: where crh.task_assignment_id = p_task_assignment_id
1793: and crl.requirement_header_id = crh.requirement_header_id
1794: and crld.requirement_line_id = crl.requirement_line_id
1795: and crld.source_type = 'RES'