APPS.ICX_REQ_COPY_REQ dependencies on PO_REQUISITION_LINES

Line 505: FROM po_requisition_lines

501: FROM SYS.DUAL;
502:
503: cursor reqlines(reqheader number) IS
504: SELECT requisition_line_id
505: FROM po_requisition_lines
506: WHERE requisition_header_id = reqheader
507: ORDER BY line_num;
508:
509: cursor reqdistributions(l_cart_id number, l_cart_line_id number) IS

Line 544: FROM po_requisition_lines

540: CLOSE getDate;
541:
542: SELECT note_to_agent
543: INTO v_note_to_buyer
544: FROM po_requisition_lines
545: WHERE requisition_header_id = l_req_header_id
546: AND rownum = 1;
547:
548:

Line 711: SELECT PO_REQUISITION_LINES_S.NEXTVAL

707: -- SELECT icx_shopping_cart_lines_s.NEXTVAL
708: -- INTO v_cart_line_id
709: -- FROM DUAL;
710: --new code:
711: SELECT PO_REQUISITION_LINES_S.NEXTVAL
712: INTO v_cart_line_id
713: FROM DUAL;
714:
715:

Line 804: FROM po_requisition_lines rl

800: v_need_by_date,
801: 'N',
802: v_deliver_to_location,
803: v_org_id
804: FROM po_requisition_lines rl
805: WHERE rl.requisition_header_id = l_req_header_id
806: AND rl.requisition_line_id = prec.requisition_line_id;
807:
808: --add by alex

Line 864: po_requisition_lines rl

860: nvl(rd.allocation_type, 'PERCENT'),
861: nvl(rd.allocation_value, round(rd.req_line_quantity / rl.quantity * 100, 5)),
862: rd.req_line_quantity
863: FROM po_req_distributions rd,
864: po_requisition_lines rl
865: WHERE rd.requisition_line_id = prec.requisition_line_id
866: AND rl.requisition_header_id = l_req_header_id
867: AND rl.requisition_line_id = rd.requisition_line_id;
868: