168: , POA_CURRENCY_PKG.get_global_currency_rate (phc.rate_type,
169: decode(phc.rate_type, 'User', gl.currency_code,
170: NVL(phc.currency_code,gl.currency_code)),
171: NVL(pod.rate_date, pod.creation_date), phc.rate)
172: , fnd_global.user_id
173: , p_start_time
174: , fnd_global.user_id
175: , p_start_time
176: , fnd_global.login_id
170: NVL(phc.currency_code,gl.currency_code)),
171: NVL(pod.rate_date, pod.creation_date), phc.rate)
172: , fnd_global.user_id
173: , p_start_time
174: , fnd_global.user_id
175: , p_start_time
176: , fnd_global.login_id
177: , fnd_global.conc_request_id
178: , fnd_global.prog_appl_id
172: , fnd_global.user_id
173: , p_start_time
174: , fnd_global.user_id
175: , p_start_time
176: , fnd_global.login_id
177: , fnd_global.conc_request_id
178: , fnd_global.prog_appl_id
179: , fnd_global.conc_program_id
180: , p_start_time
173: , p_start_time
174: , fnd_global.user_id
175: , p_start_time
176: , fnd_global.login_id
177: , fnd_global.conc_request_id
178: , fnd_global.prog_appl_id
179: , fnd_global.conc_program_id
180: , p_start_time
181: FROM poa_edw_po_dist_inc inc,
174: , fnd_global.user_id
175: , p_start_time
176: , fnd_global.login_id
177: , fnd_global.conc_request_id
178: , fnd_global.prog_appl_id
179: , fnd_global.conc_program_id
180: , p_start_time
181: FROM poa_edw_po_dist_inc inc,
182: gl_sets_of_books gl
175: , p_start_time
176: , fnd_global.login_id
177: , fnd_global.conc_request_id
178: , fnd_global.prog_appl_id
179: , fnd_global.conc_program_id
180: , p_start_time
181: FROM poa_edw_po_dist_inc inc,
182: gl_sets_of_books gl
183: , po_distributions_all pod
341: , POA_CURRENCY_PKG.get_global_currency_rate (phc.rate_type,
342: decode(phc.rate_type, 'User', gl.currency_code,
343: NVL(phc.currency_code,gl.currency_code)),
344: NVL(pod.rate_date, pod.creation_date), phc.rate)
345: , fnd_global.user_id
346: , p_start_time
347: , fnd_global.user_id
348: , p_start_time
349: , fnd_global.login_id
343: NVL(phc.currency_code,gl.currency_code)),
344: NVL(pod.rate_date, pod.creation_date), phc.rate)
345: , fnd_global.user_id
346: , p_start_time
347: , fnd_global.user_id
348: , p_start_time
349: , fnd_global.login_id
350: , fnd_global.conc_request_id
351: , fnd_global.prog_appl_id
345: , fnd_global.user_id
346: , p_start_time
347: , fnd_global.user_id
348: , p_start_time
349: , fnd_global.login_id
350: , fnd_global.conc_request_id
351: , fnd_global.prog_appl_id
352: , fnd_global.conc_program_id
353: , p_start_time
346: , p_start_time
347: , fnd_global.user_id
348: , p_start_time
349: , fnd_global.login_id
350: , fnd_global.conc_request_id
351: , fnd_global.prog_appl_id
352: , fnd_global.conc_program_id
353: , p_start_time
354: FROM poa_edw_po_dist_inc inc,
347: , fnd_global.user_id
348: , p_start_time
349: , fnd_global.login_id
350: , fnd_global.conc_request_id
351: , fnd_global.prog_appl_id
352: , fnd_global.conc_program_id
353: , p_start_time
354: FROM poa_edw_po_dist_inc inc,
355: gl_sets_of_books gl
348: , p_start_time
349: , fnd_global.login_id
350: , fnd_global.conc_request_id
351: , fnd_global.prog_appl_id
352: , fnd_global.conc_program_id
353: , p_start_time
354: FROM poa_edw_po_dist_inc inc,
355: gl_sets_of_books gl
356: , po_distributions_all pod
512: , POA_CURRENCY_PKG.get_global_currency_rate (phc.rate_type,
513: decode(phc.rate_type, 'User', gl.currency_code,
514: NVL(phc.currency_code,gl.currency_code)),
515: NVL(pod.rate_date, pod.creation_date), phc.rate)
516: , fnd_global.user_id
517: , p_start_time
518: , fnd_global.user_id
519: , p_start_time
520: , fnd_global.login_id
514: NVL(phc.currency_code,gl.currency_code)),
515: NVL(pod.rate_date, pod.creation_date), phc.rate)
516: , fnd_global.user_id
517: , p_start_time
518: , fnd_global.user_id
519: , p_start_time
520: , fnd_global.login_id
521: , fnd_global.conc_request_id
522: , fnd_global.prog_appl_id
516: , fnd_global.user_id
517: , p_start_time
518: , fnd_global.user_id
519: , p_start_time
520: , fnd_global.login_id
521: , fnd_global.conc_request_id
522: , fnd_global.prog_appl_id
523: , fnd_global.conc_program_id
524: , p_start_time
517: , p_start_time
518: , fnd_global.user_id
519: , p_start_time
520: , fnd_global.login_id
521: , fnd_global.conc_request_id
522: , fnd_global.prog_appl_id
523: , fnd_global.conc_program_id
524: , p_start_time
525: FROM poa_edw_po_dist_inc inc,
518: , fnd_global.user_id
519: , p_start_time
520: , fnd_global.login_id
521: , fnd_global.conc_request_id
522: , fnd_global.prog_appl_id
523: , fnd_global.conc_program_id
524: , p_start_time
525: FROM poa_edw_po_dist_inc inc,
526: gl_sets_of_books gl
519: , p_start_time
520: , fnd_global.login_id
521: , fnd_global.conc_request_id
522: , fnd_global.prog_appl_id
523: , fnd_global.conc_program_id
524: , p_start_time
525: FROM poa_edw_po_dist_inc inc,
526: gl_sets_of_books gl
527: , po_distributions_all pod
689: , POA_CURRENCY_PKG.get_global_currency_rate (phc.rate_type,
690: decode(phc.rate_type, 'User', gl.currency_code,
691: NVL(phc.currency_code,gl.currency_code)),
692: NVL(pod.rate_date, pod.creation_date), phc.rate)
693: , fnd_global.user_id
694: , p_start_time
695: , fnd_global.user_id
696: , p_start_time
697: , fnd_global.login_id
691: NVL(phc.currency_code,gl.currency_code)),
692: NVL(pod.rate_date, pod.creation_date), phc.rate)
693: , fnd_global.user_id
694: , p_start_time
695: , fnd_global.user_id
696: , p_start_time
697: , fnd_global.login_id
698: , fnd_global.conc_request_id
699: , fnd_global.prog_appl_id
693: , fnd_global.user_id
694: , p_start_time
695: , fnd_global.user_id
696: , p_start_time
697: , fnd_global.login_id
698: , fnd_global.conc_request_id
699: , fnd_global.prog_appl_id
700: , fnd_global.conc_program_id
701: , p_start_time
694: , p_start_time
695: , fnd_global.user_id
696: , p_start_time
697: , fnd_global.login_id
698: , fnd_global.conc_request_id
699: , fnd_global.prog_appl_id
700: , fnd_global.conc_program_id
701: , p_start_time
702: from poa_edw_po_dist_inc inc,
695: , fnd_global.user_id
696: , p_start_time
697: , fnd_global.login_id
698: , fnd_global.conc_request_id
699: , fnd_global.prog_appl_id
700: , fnd_global.conc_program_id
701: , p_start_time
702: from poa_edw_po_dist_inc inc,
703: gl_sets_of_books gl
696: , p_start_time
697: , fnd_global.login_id
698: , fnd_global.conc_request_id
699: , fnd_global.prog_appl_id
700: , fnd_global.conc_program_id
701: , p_start_time
702: from poa_edw_po_dist_inc inc,
703: gl_sets_of_books gl
704: , po_distributions_all pod