DBA Data[Home] [Help]

APPS.OKI_LOAD_OKV_PVT dependencies on OKC_CLASS_OPERATIONS

Line 402: , okc_class_operations cop

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
405: -- and convert the currency in base
406: WHERE

Line 418: -- Go from okc_k_lines_b to okc_class_operations

414: -- Get all signed and active or contracts
415: AND shd.ste_code IN ('SIGNED', 'ACTIVE')
416: -- Get priced lines
417: /*11510 changes removed the condition AND cle.price_level_ind = 'Y' */
418: -- Go from okc_k_lines_b to okc_class_operations
419: AND shd.chr_id = ole.subject_chr_id
420: AND ole.oie_id = oie.id
421: AND oie.cop_id = cop.id
422: AND shd.date_signed BETWEEN p_glpr_start_date AND p_glpr_end_date

Line 839: , okc_class_operations cop

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
842: -- and convert the currency in base
843: WHERE

Line 1258: , okc_class_operations cop

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
1261: /*11510 changes removed the following joins
1262: shd.chr_id = cle.dnz_chr_id