DBA Data[Home] [Help]

APPS.OKI_LOAD_OKV_PVT dependencies on OKC_OPERATION_LINES

Line 400: , okc_operation_lines ole

396: SELECT /*11510 changes removed NVL(SUM(cle.price_negotiated * odr.conversion_rate), 0) */ SUM(shd.base_contract_amount) base_price_negotiated
397: FROM
398: /* 11510 changes removed okc_k_lines_b cle */
399: oki_sales_k_hdrs shd
400: , okc_operation_lines ole
401: , okc_operation_instances oie
402: , okc_class_operations cop
403: /*,11510 changes removed oki_daily_rates odr */
404: -- Join lines to head to get currency code from header

Line 837: , okc_operation_lines ole

833: SELECT /*11510 changes removed NVL(SUM(cle.price_negotiated * odr.conversion_rate), 0) */ SUM(shd.base_contract_amount) base_price_negotiated
834: /* 11510 changes removed okc_k_lines_b cle */
835: FROM
836: oki_sales_k_hdrs shd
837: , okc_operation_lines ole
838: , okc_operation_instances oie
839: , okc_class_operations cop
840: /*,11510 changes removed oki_daily_rates odr */
841: -- Join lines to head to get currency code from header

Line 1256: , okc_operation_lines ole

1252: SUM(shd.base_contract_amount) base_price_negotiated
1253: /* 11510 changes removed okc_k_lines_b cle */
1254: FROM
1255: oki_sales_k_hdrs shd
1256: , okc_operation_lines ole
1257: , okc_operation_instances oie
1258: , okc_class_operations cop
1259: /*11510 changes removed oki_daily_rates odr */
1260: WHERE