APPS.ICX_REQ_NAVIGATION dependencies on PO_REQUISITION_LINES

Line 1321: from po_requisition_lines

1317: where requisition_header_id = reqheader;
1318:
1319: cursor reqlines(reqheader number) is
1320: select requisition_line_id
1321: from po_requisition_lines
1322: where requisition_header_id = reqheader;
1323:
1324: cursor get_item_number(v_cart_id number,v_cart_line_id number) is
1325: select concatenated_segments

Line 1442: from po_requisition_lines

1438: -- same deliver to, dest type, etc. for all lines
1439: select deliver_to_location_id, destination_type_code,
1440: destination_organization_id, note_to_agent
1441: into v_dlvr_loc_id, v_dest_code, v_dest_org_id, v_buyer_note
1442: from po_requisition_lines
1443: where requisition_header_id = v_req_header_id
1444: and rownum = 1;
1445:
1446: -- get the web user based on who the preparer was

Line 1616: select PO_REQUISITION_LINES_S.nextval into v_cart_line_id from dual;

1612:
1613: --changed by alex for attachment
1614: -- select icx_shopping_cart_lines_s.nextval into v_cart_line_id from dual;
1615: -- new code:
1616: select PO_REQUISITION_LINES_S.nextval into v_cart_line_id from dual;
1617:
1618:
1619: insert into icx_shopping_cart_lines (
1620: cart_line_id,

Line 1709: from po_requisition_lines rl

1705: rl.attribute15,
1706: 'N',
1707: l_location_code,
1708: v_org_id
1709: from po_requisition_lines rl
1710: where rl.requisition_header_id = v_req_header_id
1711: and rl.requisition_line_id = prec.requisition_line_id;
1712:
1713:

Line 1716: fnd_attached_documents2_pkg.copy_attachments('PO_REQUISITION_LINES',

1712:
1713:
1714: --add by alex
1715: --copy attachment for the header
1716: fnd_attached_documents2_pkg.copy_attachments('PO_REQUISITION_LINES',
1717: v_req_header_id,
1718: prec.requisition_line_id,
1719: '',
1720: '',

Line 1722: 'PO_REQUISITION_LINES',

1718: prec.requisition_line_id,
1719: '',
1720: '',
1721: '',
1722: 'PO_REQUISITION_LINES',
1723: v_cart_id,
1724: v_cart_line_id,
1725: '',
1726: '',

Line 1786: po_requisition_lines rl

1782: rd.allocation_type,
1783: rd.allocation_value,
1784: v_org_id
1785: from po_req_distributions rd,
1786: po_requisition_lines rl
1787: -- po_lines pl
1788: -- where rd.requisition_line_id = rl.requisition_line_id
1789: where rd.requisition_line_id = prec.requisition_line_id
1790: and rl.requisition_header_id = v_req_header_id