[Home] [Help]
2347: cursor check_task_req is
2348: select h.task_id, l.requirement_line_id
2349: from
2350: csp_requirement_headers h,
2351: csp_requirement_lines l,
2352: csp_req_line_details d
2353: where d.req_line_detail_id = p_req_line_detail_id
2354: and d.requirement_line_id = l.requirement_line_id
2355: and l.requirement_header_id = h.requirement_header_id
2433: cursor c_dest_info is
2434: SELECT h.destination_organization_id,
2435: h.destination_subinventory
2436: FROM csp_requirement_headers h,
2437: csp_requirement_lines l,
2438: csp_req_line_details d
2439: WHERE d.req_line_detail_id = p_req_line_detail_id
2440: AND d.requirement_line_id = l.requirement_line_id
2441: AND l.requirement_header_id = h.requirement_header_id;
2933:
2934: SELECT NVL(h.need_by_date, sysdate)
2935: INTO l_hdr_need_by
2936: FROM csp_requirement_headers h,
2937: csp_requirement_lines l
2938: WHERE l.requirement_line_id = l_requirement_line_id
2939: AND l.requirement_header_id = h.requirement_header_id;
2940:
2941: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3218: NVL(crh.need_by_date, sysdate) AS need_by_date,
3219: crld.req_line_detail_id,
3220: crl.requirement_line_id
3221: FROM csp_requirement_headers crh,
3222: csp_requirement_lines crl,
3223: csp_req_line_details crld,
3224: rcv_shipment_lines rsl,
3225: oe_order_lines_all oola,
3226: mtl_material_transactions mmt
3353:
3354: SELECT nvl(SUM(mr.reservation_quantity), 0)
3355: INTO l_already_res_qty
3356: FROM mtl_reservations mr,
3357: csp_requirement_lines cl,
3358: csp_req_line_details cd
3359: WHERE mr.reservation_id = cd.source_id
3360: AND cd.source_type = 'RES'
3361: AND cl.requirement_line_id = grd.requirement_line_id