eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OKL_STREAM_BILLING_PVT dependencies on OKL_K_HEADERS

Line 113: l_product_id okl_k_headers_full_v.pdt_id%TYPE;

109: l_bank_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
110: l_rct_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;
111: l_asst_tax OKC_RULES_B.rule_information1%TYPE;
112: l_asst_line_tax OKC_RULES_B.rule_information1%TYPE;
113: l_product_id okl_k_headers_full_v.pdt_id%TYPE;
114:
115: -- Multi Currency Compliance
116: l_currency_code OKL_EXT_SELL_INVS_B.currency_code%TYPE;
117: l_currency_conversion_type OKL_EXT_SELL_INVS_B.currency_conversion_type%TYPE;

Line 958: OKL_K_HEADERS khl,

954: FROM OKL_STRM_ELEMENTS ste,
955: OKL_STREAMS stm,
956: okl_strm_type_v sty,
957: okc_k_headers_b khr,
958: OKL_K_HEADERS khl,
959: okc_k_lines_b kle,
960: okc_statuses_b khs,
961: okc_statuses_b kls
962: WHERE ste.amount <> 0

Line 1421: FROM okl_k_headers_full_v

1417: SELECT currency_code
1418: ,currency_conversion_type
1419: ,currency_conversion_rate
1420: ,currency_conversion_date
1421: FROM okl_k_headers_full_v
1422: WHERE id = cp_khr_id;
1423:
1424: -- nikshah -- Bug # 5484903 Fixed,
1425: -- Changed CURSOR std_terms_csr SQL definition

Line 1437: FROM okl_k_headers_full_v

1433:
1434: --Get product Id
1435: CURSOR pdt_id_csr( p_khr_id NUMBER ) IS
1436: SELECT pdt_id
1437: FROM okl_k_headers_full_v
1438: WHERE id = p_khr_id;
1439: -- Variables for XTD Accounting Distributions
1440:
1441: l_esd_acc_cc_id OKL_AE_TMPT_LNES.code_combination_id%TYPE;

Line 1472: l_previous_khr OKL_K_HEADERS.khr_id%TYPE;

1468: --added variables for bankruptcy hold
1469: l_turnoff_inv_on_bankruptcy VARCHAR2(1) := 'N';
1470: l_disposition_code iex_bankruptcies.disposition_code%TYPE;
1471: l_bankruptcy_flag VARCHAR2(1) := 'N';
1472: l_previous_khr OKL_K_HEADERS.khr_id%TYPE;
1473:
1474: -- -------------------------------------------
1475: -- To support new fields in XSI and XLS
1476: -- -------------------------------------------

Line 2397: OKL_K_HEADERS khl,

2393: FROM OKL_STRM_ELEMENTS ste,
2394: OKL_STREAMS stm,
2395: okl_strm_type_v sty,
2396: okc_k_headers_b khr,
2397: OKL_K_HEADERS khl,
2398: okc_k_lines_b kle,
2399: okc_statuses_b khs,
2400: okc_statuses_b kls
2401: WHERE TRUNC(ste.stream_element_date) >=

Line 2450: OKL_K_HEADERS khl,

2446: FROM OKL_STRM_ELEMENTS ste,
2447: OKL_STREAMS stm,
2448: okl_strm_type_v sty,
2449: okc_k_headers_b khr,
2450: OKL_K_HEADERS khl,
2451: okc_k_lines_b kle,
2452: okc_statuses_b khs,
2453: okc_statuses_b kls,
2454: okc_k_lines_b cle

Line 2498: OKL_K_HEADERS khl,

2494: FROM OKL_STRM_ELEMENTS ste,
2495: OKL_STREAMS stm,
2496: okl_strm_type_v sty,
2497: okc_k_headers_b khr,
2498: OKL_K_HEADERS khl,
2499: okc_k_lines_b kle,
2500: okc_statuses_b khs,
2501: okc_statuses_b kls
2502: WHERE TRUNC(ste.stream_element_date) >=

Line 2559: OKL_K_HEADERS khl,

2555: FROM OKL_STRM_ELEMENTS ste,
2556: OKL_STREAMS stm,
2557: okl_strm_type_v sty,
2558: okc_k_headers_b khr,
2559: OKL_K_HEADERS khl,
2560: okc_k_lines_b kle,
2561: okc_statuses_b khs,
2562: okc_statuses_b kls
2563: WHERE TRUNC(ste.stream_element_date) >=

Line 2619: OKL_K_HEADERS khl,

2615: FROM OKL_STRM_ELEMENTS ste,
2616: OKL_STREAMS stm,
2617: okl_strm_type_v sty,
2618: okc_k_headers_b khr,
2619: OKL_K_HEADERS khl,
2620: okc_k_lines_b kle,
2621: okc_statuses_b khs,
2622: okc_statuses_b kls
2623: WHERE TRUNC(ste.stream_element_date) >=

Line 2671: OKL_K_HEADERS khl,

2667: FROM OKL_STRM_ELEMENTS ste,
2668: OKL_STREAMS stm,
2669: okl_strm_type_v sty,
2670: okc_k_headers_b khr,
2671: OKL_K_HEADERS khl,
2672: okc_k_lines_b kle,
2673: okc_statuses_b khs,
2674: okc_statuses_b kls,
2675: okc_k_lines_b cle

Line 2720: OKL_K_HEADERS khl,

2716: FROM OKL_STRM_ELEMENTS ste,
2717: OKL_STREAMS stm,
2718: okl_strm_type_v sty,
2719: okc_k_headers_b khr,
2720: OKL_K_HEADERS khl,
2721: okc_k_lines_b kle,
2722: okc_statuses_b khs,
2723: okc_statuses_b kls
2724: WHERE TRUNC(ste.stream_element_date) >=

Line 2780: OKL_K_HEADERS khl,

2776: FROM OKL_STRM_ELEMENTS ste,
2777: OKL_STREAMS stm,
2778: okl_strm_type_v sty,
2779: okc_k_headers_b khr,
2780: OKL_K_HEADERS khl,
2781: okc_k_lines_b kle,
2782: okc_statuses_b khs,
2783: okc_statuses_b kls
2784: WHERE TRUNC(ste.stream_element_date) >=

Line 2840: OKL_K_HEADERS khl,

2836: FROM OKL_STRM_ELEMENTS ste,
2837: OKL_STREAMS stm,
2838: okl_strm_type_v sty,
2839: okc_k_headers_b khr,
2840: OKL_K_HEADERS khl,
2841: okc_k_lines_b kle,
2842: okc_statuses_b khs,
2843: okc_statuses_b kls,
2844: OKL_PARALLEL_PROCESSES pws

Line 2895: OKL_K_HEADERS khl,

2891: FROM OKL_STRM_ELEMENTS ste,
2892: OKL_STREAMS stm,
2893: okl_strm_type_v sty,
2894: okc_k_headers_b khr,
2895: OKL_K_HEADERS khl,
2896: okc_k_lines_b kle,
2897: okc_statuses_b khs,
2898: okc_statuses_b kls,
2899: okc_k_lines_b cle,

Line 2948: OKL_K_HEADERS khl,

2944: FROM OKL_STRM_ELEMENTS ste,
2945: OKL_STREAMS stm,
2946: okl_strm_type_v sty,
2947: okc_k_headers_b khr,
2948: OKL_K_HEADERS khl,
2949: okc_k_lines_b kle,
2950: okc_statuses_b khs,
2951: okc_statuses_b kls,
2952: OKL_PARALLEL_PROCESSES pws

Line 3011: OKL_K_HEADERS khl,

3007: FROM OKL_STRM_ELEMENTS ste,
3008: OKL_STREAMS stm,
3009: okl_strm_type_v sty,
3010: okc_k_headers_b khr,
3011: OKL_K_HEADERS khl,
3012: okc_k_lines_b kle,
3013: okc_statuses_b khs,
3014: okc_statuses_b kls,
3015: OKL_PARALLEL_PROCESSES pws