[Home] [Help]
209: po_lines_all pol,
210: po_line_locations_all pll,
211: po_distributions_all pod,
212: po_releases_all por,
213: financials_system_params_all pfsp,
214: financials_system_params_all rfsp,
215: gl_sets_of_books pgl,
216: gl_sets_of_books rgl
217: WHERE
210: po_line_locations_all pll,
211: po_distributions_all pod,
212: po_releases_all por,
213: financials_system_params_all pfsp,
214: financials_system_params_all rfsp,
215: gl_sets_of_books pgl,
216: gl_sets_of_books rgl
217: WHERE
218: rhr.authorization_status = 'APPROVED'
333: po_requisition_headers_all rhr,
334: po_requisition_lines_all rln,
335: po_headers_all poh,
336: po_line_locations_all pll,
337: financials_system_params_all pfsp,
338: financials_system_params_all rfsp,
339: gl_sets_of_books pgl,
340: gl_sets_of_books rgl,
341: po_req_distributions_all rdn,
334: po_requisition_lines_all rln,
335: po_headers_all poh,
336: po_line_locations_all pll,
337: financials_system_params_all pfsp,
338: financials_system_params_all rfsp,
339: gl_sets_of_books pgl,
340: gl_sets_of_books rgl,
341: po_req_distributions_all rdn,
342: po_distributions_all pod
369: po_requisition_headers_all rhr,
370: po_requisition_lines_all rln,
371: po_headers_all poh,
372: po_line_locations_all pll,
373: financials_system_params_all pfsp,
374: financials_system_params_all rfsp,
375: gl_sets_of_books pgl,
376: gl_sets_of_books rgl,
377: po_req_distributions_all rdn,
370: po_requisition_lines_all rln,
371: po_headers_all poh,
372: po_line_locations_all pll,
373: financials_system_params_all pfsp,
374: financials_system_params_all rfsp,
375: gl_sets_of_books pgl,
376: gl_sets_of_books rgl,
377: po_req_distributions_all rdn,
378: po_distributions_all pod
405: po_requisition_headers_all rhr,
406: po_requisition_lines_all rln,
407: po_headers_all poh,
408: po_line_locations_all pll,
409: financials_system_params_all pfsp,
410: financials_system_params_all rfsp,
411: gl_sets_of_books pgl,
412: gl_sets_of_books rgl,
413: po_req_distributions_all rdn,
406: po_requisition_lines_all rln,
407: po_headers_all poh,
408: po_line_locations_all pll,
409: financials_system_params_all pfsp,
410: financials_system_params_all rfsp,
411: gl_sets_of_books pgl,
412: gl_sets_of_books rgl,
413: po_req_distributions_all rdn,
414: po_distributions_all pod
441: po_requisition_headers_all rhr,
442: po_requisition_lines_all rln,
443: po_headers_all poh,
444: po_line_locations_all pll,
445: financials_system_params_all pfsp,
446: financials_system_params_all rfsp,
447: gl_sets_of_books pgl,
448: gl_sets_of_books rgl,
449: po_req_distributions_all rdn,
442: po_requisition_lines_all rln,
443: po_headers_all poh,
444: po_line_locations_all pll,
445: financials_system_params_all pfsp,
446: financials_system_params_all rfsp,
447: gl_sets_of_books pgl,
448: gl_sets_of_books rgl,
449: po_req_distributions_all rdn,
450: po_distributions_all pod
478: po_requisition_lines_all rln,
479: po_headers_all poh,
480: po_lines_all pol,
481: po_line_locations_all pll,
482: financials_system_params_all pfsp,
483: financials_system_params_all rfsp,
484: gl_sets_of_books pgl,
485: gl_sets_of_books rgl,
486: po_req_distributions_all rdn,
479: po_headers_all poh,
480: po_lines_all pol,
481: po_line_locations_all pll,
482: financials_system_params_all pfsp,
483: financials_system_params_all rfsp,
484: gl_sets_of_books pgl,
485: gl_sets_of_books rgl,
486: po_req_distributions_all rdn,
487: po_distributions_all pod
516: po_requisition_lines_all rln,
517: po_headers_all poh,
518: po_line_locations_all pll,
519: po_releases_all por,
520: financials_system_params_all pfsp,
521: financials_system_params_all rfsp,
522: gl_sets_of_books pgl,
523: gl_sets_of_books rgl,
524: po_req_distributions_all rdn,
517: po_headers_all poh,
518: po_line_locations_all pll,
519: po_releases_all por,
520: financials_system_params_all pfsp,
521: financials_system_params_all rfsp,
522: gl_sets_of_books pgl,
523: gl_sets_of_books rgl,
524: po_req_distributions_all rdn,
525: po_distributions_all pod
552: rgl.currency_code func_cur_code ,
553: nvl(trunc(rln.rate_date),trunc(rln.creation_date)) rate_date
554: FROM po_requisition_headers_all rhr,
555: po_requisition_lines_all rln,
556: financials_system_params_all rfsp,
557: gl_sets_of_books rgl
558: WHERE rhr.authorization_status='INCOMPLETE'
559: and rln.source_type_code = 'VENDOR'
560: and rln.requisition_header_id = rhr.requisition_header_id
575: rgl.currency_code func_cur_code,
576: nvl(trunc(rln.rate_date),trunc(rln.creation_date)) rate_date
577: FROM po_requisition_headers_all rhr,
578: po_requisition_lines_all rln,
579: financials_system_params_all rfsp,
580: gl_sets_of_books rgl
581: WHERE rhr.authorization_status='INCOMPLETE'
582: and rln.source_type_code = 'VENDOR'
583: and rln.requisition_header_id = rhr.requisition_header_id
971: po_req_distributions_all rdn,
972: po_headers_all poh,
973: po_lines_all pol,
974: po_releases_all por,
975: financials_system_params_all pfsp,
976: mtl_parameters ppar,
977: mtl_system_items pitem,
978: financials_system_params_all rfsp,
979: mtl_parameters rpar,
974: po_releases_all por,
975: financials_system_params_all pfsp,
976: mtl_parameters ppar,
977: mtl_system_items pitem,
978: financials_system_params_all rfsp,
979: mtl_parameters rpar,
980: mtl_system_items ritem,
981: gl_sets_of_books pgl,
982: gl_sets_of_books rgl,
1426: po_req_distributions_all rdn,
1427: po_headers_all poh,
1428: po_lines_all pol,
1429: po_releases_all por,
1430: financials_system_params_all pfsp,
1431: mtl_parameters ppar,
1432: mtl_system_items pitem,
1433: financials_system_params_all rfsp,
1434: mtl_parameters rpar,
1429: po_releases_all por,
1430: financials_system_params_all pfsp,
1431: mtl_parameters ppar,
1432: mtl_system_items pitem,
1433: financials_system_params_all rfsp,
1434: mtl_parameters rpar,
1435: mtl_system_items ritem,
1436: gl_sets_of_books pgl,
1437: gl_sets_of_books rgl,