DBA Data[Home] [Help]

APPS.POA_DBI_PO_DIST_F_C dependencies on POA_GA_UTIL_PKG

Line 1447: , nvl(blanket.bl_rate, 1) * decode(blanket.bl_func_cur_code, ptmp3.func_cur_code, 1, poa_ga_util_pkg.get_ga_conversion_rate(blanket.bl_func_cur_code, ptmp3.func_cur_code, ptmp3.rate_date)) cur_conversion_rate

1443: blanket.b_item_id,
1444: pb.creation_date,
1445: blanket.po_header_id,
1446: blanket.vendor_id
1447: , nvl(blanket.bl_rate, 1) * decode(blanket.bl_func_cur_code, ptmp3.func_cur_code, 1, poa_ga_util_pkg.get_ga_conversion_rate(blanket.bl_func_cur_code, ptmp3.func_cur_code, ptmp3.rate_date)) cur_conversion_rate
1448: -- convert to blanket functional currency and then to standard PO functional currency
1449: ,(case when pb.ship_to_location_id = ptmp3.ship_to_location_id
1450: and ( pb.quantity is null or ( price_break_lookup_code = 'NON CUMULATIVE' and ptmp3.quantity >= pb.quantity)
1451: or (price_break_lookup_code = 'CUMULATIVE' and ptmp3.quantity + blanket.line_qty >= pb.quantity))