DBA Data[Home] [Help]

APPS.CSF_DEBRIEF_UPDATE_PKG dependencies on CSP_REQUIREMENT_LINES

Line 485: csp_requirement_lines crl,

481: SELECT mr.inventory_item_id,
482: mr.reservation_uom_code,
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

Line 1789: csp_requirement_lines crl,

1785: cursor reservations
1786: is
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