DBA Data[Home] [Help]

APPS.CSR_SCHEDULER_PVT dependencies on CSP_REQ_LINE_DETAILS

Line 1187: FROM csp_req_line_details crld

1183: l_status varchar2(30);
1184:
1185: CURSOR c_get_reservations is
1186: SELECT 'Y'
1187: FROM csp_req_line_details crld
1188: , csp_requirement_lines crl
1189: , csp_requirement_headers crh
1190: WHERE crh.task_assignment_id = p_task_assignment_id
1191: AND crl.requirement_header_id = crh.requirement_header_id

Line 1197: FROM csp_req_line_details crld

1193: AND crld.source_type = 'RES' ;
1194:
1195: CURSOR c_get_orders is
1196: SELECT 'Y'
1197: FROM csp_req_line_details crld
1198: , csp_requirement_lines crl
1199: , csp_requirement_headers crh
1200: , oe_order_lines_all oel
1201: , oe_order_headers_all oeh