DBA Data[Home] [Help]

APPS.CSF_DEBRIEF_LINES_PKG dependencies on CSP_REQUIREMENT_LINES

Line 40: csp_requirement_lines crl,

36: is
37: select sum(mr.reservation_quantity)
38: from csf_debrief_headers cdh,
39: csp_requirement_headers crh,
40: csp_requirement_lines crl,
41: csp_req_line_details crld,
42: mtl_reservations mr
43: where cdh.debrief_header_id = p_dbf_hdr_id
44: and crh.task_assignment_id = cdh.task_assignment_id

Line 67: csp_requirement_lines crl

63: is
64: select crl.requirement_line_id
65: from csf_debrief_headers cdh,
66: csp_requirement_headers crh,
67: csp_requirement_lines crl
68: where cdh.debrief_header_id = p_dbf_hdr_id
69: and crh.task_assignment_id = cdh.task_assignment_id
70: and crl.requirement_header_id = crh.requirement_header_id
71: and crl.inventory_item_id = p_inventory_item_id