APPS.ICX_PO_REQ_ACCT2 dependencies on PO_REQUISITION_LINES

Line 26: po_requisition_lines b,

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

Line 46: from po_requisition_lines a,

42: and gl.CODE_COMBINATION_ID = acct_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

Line 55: from po_requisition_lines

51: and nvl(a.org_id,-9999) = nvl(oo_id,-9999);
52: /*
53: cursor get_line_number(cartid number, cartline_id number, oo_id number) is
54: select line_num
55: from po_requisition_lines
56: where requisition_line_id = cartline_id
57: and requisition_header_id = cartid
58: and nvl(org_id,-9999) = nvl(oo_id,-9999);
59: */

Line 203: po_requisition_lines b,

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

Line 213: from po_requisition_lines a,

209: and nvl(a.org_id,-9999) = nvl(v_oo_id,-9999);
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

Line 244: po_requisition_lines isc

240: isc.SUGGESTED_VENDOR_LOCATION
241: FROM financials_system_parameters fsp,
242: hr_employees_current_v hecv,
243: mtl_system_items msi,
244: po_requisition_lines isc
245: where isc.requisition_line_id = reqline_id
246: and msi.INVENTORY_ITEM_ID (+) = isc.ITEM_ID
247: and nvl(msi.ORGANIZATION_ID, isc.DESTINATION_ORGANIZATION_ID) = isc.DESTINATION_ORGANIZATION_ID
248: and hecv.EMPLOYEE_ID = emp_id

Line 253: from po_requisition_lines a,

249: and nvl(isc.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

Line 829: po_requisition_lines b,

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

Line 845: from po_requisition_lines a,

841: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_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

Line 962: po_requisition_lines b,

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

Line 978: from po_requisition_lines a,

974: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_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

Line 1260: po_requisition_lines pol

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)) =
1264: nvl(pol.DESTINATION_ORGANIZATION_ID, -999)

Line 1280: from po_requisition_lines a,

1276: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
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;