309: , POA_CURRENCY_PKG.get_global_currency_rate (phc.rate_type,
310: decode(phc.rate_type, 'User', gl.currency_code,
311: NVL(phc.currency_code, gl.currency_code)),
312: NVL(pod.rate_date, pod.creation_date), phc.rate)
313: , fnd_global.user_id
314: , p_start_time
315: , fnd_global.user_id
316: , p_start_time
317: , fnd_global.login_id
311: NVL(phc.currency_code, gl.currency_code)),
312: NVL(pod.rate_date, pod.creation_date), phc.rate)
313: , fnd_global.user_id
314: , p_start_time
315: , fnd_global.user_id
316: , p_start_time
317: , fnd_global.login_id
318: , fnd_global.conc_request_id
319: , fnd_global.prog_appl_id
313: , fnd_global.user_id
314: , p_start_time
315: , fnd_global.user_id
316: , p_start_time
317: , fnd_global.login_id
318: , fnd_global.conc_request_id
319: , fnd_global.prog_appl_id
320: , fnd_global.conc_program_id
321: , p_start_time
314: , p_start_time
315: , fnd_global.user_id
316: , p_start_time
317: , fnd_global.login_id
318: , fnd_global.conc_request_id
319: , fnd_global.prog_appl_id
320: , fnd_global.conc_program_id
321: , p_start_time
322: FROM poa_edw_po_dist_inc inc,
315: , fnd_global.user_id
316: , p_start_time
317: , fnd_global.login_id
318: , fnd_global.conc_request_id
319: , fnd_global.prog_appl_id
320: , fnd_global.conc_program_id
321: , p_start_time
322: FROM poa_edw_po_dist_inc inc,
323: gl_sets_of_books gl
316: , p_start_time
317: , fnd_global.login_id
318: , fnd_global.conc_request_id
319: , fnd_global.prog_appl_id
320: , fnd_global.conc_program_id
321: , p_start_time
322: FROM poa_edw_po_dist_inc inc,
323: gl_sets_of_books gl
324: , po_distributions_all pod
490: , POA_CURRENCY_PKG.get_global_currency_rate (phc.rate_type,
491: decode(phc.rate_type, 'User', gl.currency_code,
492: NVL(phc.currency_code,gl.currency_code)),
493: NVL(pod.rate_date, pod.creation_date), phc.rate)
494: , fnd_global.user_id
495: , p_start_time
496: , fnd_global.user_id
497: , p_start_time
498: , fnd_global.login_id
492: NVL(phc.currency_code,gl.currency_code)),
493: NVL(pod.rate_date, pod.creation_date), phc.rate)
494: , fnd_global.user_id
495: , p_start_time
496: , fnd_global.user_id
497: , p_start_time
498: , fnd_global.login_id
499: , fnd_global.conc_request_id
500: , fnd_global.prog_appl_id
494: , fnd_global.user_id
495: , p_start_time
496: , fnd_global.user_id
497: , p_start_time
498: , fnd_global.login_id
499: , fnd_global.conc_request_id
500: , fnd_global.prog_appl_id
501: , fnd_global.conc_program_id
502: , p_start_time
495: , p_start_time
496: , fnd_global.user_id
497: , p_start_time
498: , fnd_global.login_id
499: , fnd_global.conc_request_id
500: , fnd_global.prog_appl_id
501: , fnd_global.conc_program_id
502: , p_start_time
503: FROM poa_edw_po_dist_inc inc,
496: , fnd_global.user_id
497: , p_start_time
498: , fnd_global.login_id
499: , fnd_global.conc_request_id
500: , fnd_global.prog_appl_id
501: , fnd_global.conc_program_id
502: , p_start_time
503: FROM poa_edw_po_dist_inc inc,
504: gl_sets_of_books gl
497: , p_start_time
498: , fnd_global.login_id
499: , fnd_global.conc_request_id
500: , fnd_global.prog_appl_id
501: , fnd_global.conc_program_id
502: , p_start_time
503: FROM poa_edw_po_dist_inc inc,
504: gl_sets_of_books gl
505: , po_distributions_all pod
928: ,NULL
929: ,v_rate
930: ,v_approved_date
931: ,v_Currency_Conv_Rate
932: ,fnd_global.user_id
933: ,p_start_time
934: ,fnd_global.user_id
935: ,p_start_time
936: ,fnd_global.login_id
930: ,v_approved_date
931: ,v_Currency_Conv_Rate
932: ,fnd_global.user_id
933: ,p_start_time
934: ,fnd_global.user_id
935: ,p_start_time
936: ,fnd_global.login_id
937: ,fnd_global.conc_request_id
938: ,fnd_global.prog_appl_id
932: ,fnd_global.user_id
933: ,p_start_time
934: ,fnd_global.user_id
935: ,p_start_time
936: ,fnd_global.login_id
937: ,fnd_global.conc_request_id
938: ,fnd_global.prog_appl_id
939: ,fnd_global.conc_program_id
940: ,p_start_time);
933: ,p_start_time
934: ,fnd_global.user_id
935: ,p_start_time
936: ,fnd_global.login_id
937: ,fnd_global.conc_request_id
938: ,fnd_global.prog_appl_id
939: ,fnd_global.conc_program_id
940: ,p_start_time);
941:
934: ,fnd_global.user_id
935: ,p_start_time
936: ,fnd_global.login_id
937: ,fnd_global.conc_request_id
938: ,fnd_global.prog_appl_id
939: ,fnd_global.conc_program_id
940: ,p_start_time);
941:
942:
935: ,p_start_time
936: ,fnd_global.login_id
937: ,fnd_global.conc_request_id
938: ,fnd_global.prog_appl_id
939: ,fnd_global.conc_program_id
940: ,p_start_time);
941:
942:
943: --