[Home] [Help]
23: cursor dist_acct is
24: select a.code_combination_id code_combination_id
25: from po_req_distributions a,
26: po_requisition_lines b,
27: po_requisition_headers c
28: where a.requisition_line_id = v_cart_line_id
29: and a.requisition_line_id = b.requisition_line_id
30: and b.requisition_header_id = v_cart_id
31: and b.requisition_header_id = c.requisition_header_id
43:
44: cursor get_line_number(cartid number, cartline_id number, oo_id number) is
45: select a.line_num
46: from po_requisition_lines a,
47: po_requisition_headers b
48: where a.requisition_line_id = cartline_id
49: and a.requisition_header_id = cartid
50: and a.requisition_header_id = b.requisition_header_id
51: and nvl(a.org_id,-9999) = nvl(oo_id,-9999);
200: cursor get_dist_num is
201: select max(a.distribution_num)
202: from po_req_distributions a,
203: po_requisition_lines b,
204: po_requisition_headers c
205: where a.requisition_line_id = v_cart_line_id
206: and b.requisition_line_id = a.requisition_line_id
207: and b.requisition_header_id = v_cart_id
208: and b.requisition_header_id = c.requisition_header_id
210:
211: cursor get_req_line_number is
212: select a.line_num
213: from po_requisition_lines a,
214: po_requisition_headers b
215: where a.requisition_line_id = v_cart_line_id
216: and a.requisition_header_id = v_cart_id
217: and a.requisition_header_id = b.requisition_header_id
218: and nvl(a.org_id,-9999) = nvl(v_oo_id,-9999);
250:
251: cursor get_emp_id(line_id number) is
252: select to_person_id
253: from po_requisition_lines a,
254: po_requisition_headers b
255: where a.requisition_line_id = line_id
256: and a.requisition_header_id = v_cart_id
257: and a.requisition_header_id = b.requisition_header_id
258: and nvl(a.org_id,-9999) = nvl(v_oo_id,-9999);
826: cursor get_dist_num(cartline_id number,oo_id number) is
827: select max(a.distribution_num)
828: from po_req_distributions a,
829: po_requisition_lines b,
830: po_requisition_headers c
831: where a.requisition_line_id = cartline_id
832: and a.requisition_line_id = b.requisition_line_id
833: and b.requisition_header_id = v_cart_id
834: and b.requisition_header_id = c.requisition_header_id
842:
843: cursor get_line_number(cartline_id number, oo_id number) is
844: select a.line_num
845: from po_requisition_lines a,
846: po_requisition_headers b
847: where a.requisition_line_id = cartline_id
848: and a.requisition_header_id = v_cart_id
849: and a.requisition_header_id = b.requisition_header_id
850: and nvl(a.org_id, -9999) = nvl(oo_id,-9999);
959: cursor get_dist_number(reqline_id number,oo_id number) is
960: select max(a.distribution_num)
961: from po_req_distributions a,
962: po_requisition_lines b,
963: po_requisition_headers c
964: where a.requisition_line_id = reqline_id
965: and a.requisition_line_id = b.requisition_line_id
966: and b.requisition_header_id = v_cart_id
967: and b.requisition_header_id = c.requisition_header_id
975:
976: cursor get_req_line_number(reqline_id number) is
977: select a.line_num
978: from po_requisition_lines a,
979: po_requisition_headers b
980: where a.requisition_line_id = reqline_id
981: and a.requisition_header_id = v_cart_id
982: and a.requisition_header_id = b.requisition_header_id
983: and nvl(a.org_id, -9999) = nvl(v_oo_id,-9999);
1255:
1256: CURSOR item_expense_account is
1257: select msi.expense_account
1258: from mtl_system_items msi,
1259: po_requisition_headers poh,
1260: po_requisition_lines pol
1261: where msi.inventory_item_id(+) = pol.item_id
1262: AND nvl(msi.ORGANIZATION_ID,
1263: NVL(pol.DESTINATION_ORGANIZATION_ID, -999)) =
1277:
1278: cursor get_req_line_number is
1279: select a.line_num
1280: from po_requisition_lines a,
1281: po_requisition_headers b
1282: where a.requisition_header_id = v_cart_id
1283: and a.requisition_header_id = b.requisition_header_id
1284: and a.requisition_line_id = v_cart_line_id;
1285: