DBA Data[Home] [Help]

APPS.CSP_TRANSACTIONS_PUB dependencies on CSP_REQUIREMENT_HEADERS

Line 2350: csp_requirement_headers h,

2346:
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

Line 2436: FROM csp_requirement_headers h,

2432:
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

Line 2936: FROM csp_requirement_headers h,

2932: if l_task_id is not null then
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:

Line 3221: FROM csp_requirement_headers crh,

3217: mmt.transaction_uom AS uom,
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,