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.

APPS.OKS_MASS_UPD_PVT dependencies on OKC_K_LINES_B

Line 518: FROM okc_k_lines_b cleb, oks_k_lines_B kln

514: WHERE id = p_contract_id;
515:
516: cursor cur_line(p_subline_id in number) is
517: SELECT cleb.price_negotiated, kln.tax_amount
518: FROM okc_k_lines_b cleb, oks_k_lines_B kln
519: WHERE cleb.id = p_subline_id
520: AND cleb.id = kln.cle_id;
521:
522: -- Header Tax Total

Line 525: FROM okc_k_lines_b cle, oks_k_lines_b kln

521:
522: -- Header Tax Total
523: Cursor hdrtax_cur(p_chr_id In Number) Is
524: SELECT SUM(kln.tax_amount)
525: FROM okc_k_lines_b cle, oks_k_lines_b kln
526: WHERE cle.dnz_chr_id = p_chr_id
527: AND cle.id = kln.cle_id
528: AND cle.lse_id IN (7, 8, 9, 10, 11, 13, 35, 25, 46)
529: AND cle.date_cancelled IS NULL;

Line 534: FROM okc_k_lines_b cle, oks_k_lines_b kln

530:
531: -- Topline Tax Total
532: Cursor toplinetax_cur(p_cle_id In Number) Is
533: SELECT SUM(tax_amount)
534: FROM okc_k_lines_b cle, oks_k_lines_b kln
535: WHERE cle.cle_id = p_cle_id
536: AND cle.id = kln.cle_id
537: AND cle.lse_id IN (7, 8, 9, 10, 11, 13, 35, 25, 46)
538: AND cle.date_cancelled IS NULL;

Line 547: FROM OKC_K_LINES_B

543: WHERE chr_id = p_chr_id;
544:
545: CURSOR check_line_status(p_hdr_id IN NUMBER,p_line_id IN NUMBER ) IS
546: SELECT 'Y'
547: FROM OKC_K_LINES_B
548: WHERE dnz_chr_id = p_hdr_id
549: AND id = p_line_id
550: AND (date_terminated IS NULL OR date_terminated > TRUNC(SYSDATE))
551: AND date_cancelled IS NULL

Line 1584: FROM OKC_K_LINES_B

1580: L_GET_SUB_LINE_DATE_REC L_GET_SUB_LINE_DATE_CSR%ROWTYPE;
1581:
1582: CURSOR L_GET_TOP_LINE_DATES_CSR(P_TOP_LINE_ID IN NUMBER) IS
1583: SELECT TRUNC(START_DATE) START_DATE, TRUNC(END_DATE) END_DATE
1584: FROM OKC_K_LINES_B
1585: WHERE ID = P_TOP_LINE_ID;
1586:
1587: L_GET_TOP_LINE_DATES_REC L_GET_TOP_LINE_DATES_CSR%ROWTYPE;
1588:

Line 1774: FROM OKC_K_LINES_B sl, okc_k_lines_b l

1770: exception_yn := 'N'; -- Defaulting value
1771: fnd_file.put_line (fnd_file.log, l_api_name || ', Checking Contract SubLine Effectivity for Subline Number: ' || p_line_number);
1772: select l.chr_id, l.START_DATE, l.END_DATE
1773: INTO l_chr_id, l_kl_start_date, l_kl_end_date
1774: FROM OKC_K_LINES_B sl, okc_k_lines_b l
1775: WHERE sl.id = p_subline_id
1776: AND sl.cle_id = l.id;
1777:
1778: IF (p_start_date < l_kl_start_date OR p_start_date > l_kl_end_date) THEN

Line 1843: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := 'Error while fetching data from okc_k_lines_b for subline, Error: ' || SQLERRM;

1839: EXCEPTION
1840: WHEN OTHERS THEN
1841: exception_yn := 'Y';
1842: l_err_mu_eff_tbl(l_err_eff_idx).line_number := p_line_number;
1843: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := 'Error while fetching data from okc_k_lines_b for subline, Error: ' || SQLERRM;
1844: l_err_eff_idx := l_err_eff_idx +1;
1845: fnd_file.put_line (fnd_file.output, l_api_name ||
1846: ' Error while validating data in check_new_subline_effectivity for subline number: ' || p_line_number);
1847: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 1898: Select id From OKC_K_LINES_b Where cle_id = p_line_id;

1894: x_overall_status VARCHAR2(1);
1895: --l_err_mu_eff_tbl err_mu_eff_tbl;
1896:
1897: Cursor LineCov_cur(p_line_id IN Number) Is
1898: Select id From OKC_K_LINES_b Where cle_id = p_line_id;
1899:
1900: CURSOR check_eligiblity_line(p_hdr_id NUMBER, p_line_id NUMBER, p_intent VARCHAR2) IS
1901: SELECT 'Y'
1902: FROM OKC_K_LINES_B

Line 1902: FROM OKC_K_LINES_B

1898: Select id From OKC_K_LINES_b Where cle_id = p_line_id;
1899:
1900: CURSOR check_eligiblity_line(p_hdr_id NUMBER, p_line_id NUMBER, p_intent VARCHAR2) IS
1901: SELECT 'Y'
1902: FROM OKC_K_LINES_B
1903: WHERE dnz_chr_id = p_hdr_id
1904: AND id = p_line_id
1905: AND (date_terminated IS NULL OR date_terminated > TRUNC(SYSDATE))
1906: AND date_cancelled IS NULL

Line 1921: FROM okc_k_lines_b

1917: IF p_mass_update_effectivity_tbl(i).sub_line_id IS NULL THEN
1918: BEGIN
1919: SELECT sts_code
1920: INTO l_clev_tbl_kl_in(p) .sts_code
1921: FROM okc_k_lines_b
1922: where id = p_mass_update_effectivity_tbl(i).line_id;
1923: EXCEPTION
1924: when OTHERS THEN
1925: l_err_mu_eff_tbl(l_err_eff_idx).line_number := p_mass_update_effectivity_tbl(i).line_number;

Line 1926: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := 'Error while fetching data from okc_k_lines_b for line';

1922: where id = p_mass_update_effectivity_tbl(i).line_id;
1923: EXCEPTION
1924: when OTHERS THEN
1925: l_err_mu_eff_tbl(l_err_eff_idx).line_number := p_mass_update_effectivity_tbl(i).line_number;
1926: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := 'Error while fetching data from okc_k_lines_b for line';
1927: l_err_eff_idx := l_err_eff_idx +1;
1928:
1929: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1930: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 1932: ' Error while fetching data from okc_k_lines_b, line number: ' || p_mass_update_effectivity_tbl(i).line_number);

1928:
1929: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1930: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1931: l_api_name,
1932: ' Error while fetching data from okc_k_lines_b, line number: ' || p_mass_update_effectivity_tbl(i).line_number);
1933: END IF;
1934: END;
1935:
1936: OPEN check_eligiblity_line(p_mass_update_effectivity_tbl(i).chr_id,

Line 2063: FROM okc_k_lines_b

2059:
2060: BEGIN
2061: SELECT sts_code
2062: INTO l_clev_tbl_sl_in(q).sts_code
2063: FROM okc_k_lines_b
2064: where id = p_mass_update_effectivity_tbl(i).sub_line_id;
2065: EXCEPTION
2066: when OTHERS THEN
2067: l_err_mu_eff_tbl(l_err_eff_idx).line_number := p_mass_update_effectivity_tbl(i).line_number;

Line 2068: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := 'Error while fetching data from okc_k_lines_b for Subline';

2064: where id = p_mass_update_effectivity_tbl(i).sub_line_id;
2065: EXCEPTION
2066: when OTHERS THEN
2067: l_err_mu_eff_tbl(l_err_eff_idx).line_number := p_mass_update_effectivity_tbl(i).line_number;
2068: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := 'Error while fetching data from okc_k_lines_b for Subline';
2069: l_err_eff_idx := l_err_eff_idx +1;
2070: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2071: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2072: l_api_name,

Line 2073: ' Error while fetching data from okc_k_lines_b');

2069: l_err_eff_idx := l_err_eff_idx +1;
2070: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2071: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2072: l_api_name,
2073: ' Error while fetching data from okc_k_lines_b');
2074: END IF;
2075: END;
2076:
2077: OPEN check_eligiblity_line(p_mass_update_effectivity_tbl(i).chr_id,

Line 2827: FROM okc_k_lines_b lin,

2823: Price_negotiated,
2824: lin.start_date,
2825: lin.end_date,
2826: Price_negotiated
2827: FROM okc_k_lines_b lin,
2828: okc_k_items itm,
2829: OKX_SYSTEM_ITEMS_V SI,
2830: okc_statuses_b sts
2831: WHERE lin.id = itm.cle_id

Line 2879: FROM okc_k_lines_b line

2875: To_Char(lin.cle_id),
2876: To_Char(lin.dnz_chr_id),
2877: lin.lse_id,
2878: (SELECT line_number
2879: FROM okc_k_lines_b line
2880: WHERE line.id = lin.cle_id) || '.' || lin.line_number line_number,
2881: cs_item.customer_product_id,
2882: SI.name,
2883: SI.description,

Line 3039: okc_k_lines_b lin,

3035: a.config_parent_id)
3036: END top_lvl_parent,*/
3037:
3038: FROM okc_k_items itm,
3039: okc_k_lines_b lin,
3040: OKX_SYSTEM_ITEMS_V SI,
3041: oks_ib_config_v cs_item,
3042: okc_statuses_b sts,
3043: CSI_SYSTEMS_TL CSTL

Line 3062: FROM okc_k_lines_b line

3058: To_Char(lin.cle_id),
3059: To_Char(lin.dnz_chr_id),
3060: lin.lse_id,
3061: (SELECT line_number
3062: FROM okc_k_lines_b line
3063: WHERE line.id = lin.cle_id) || '.' || lin.line_number line_number,
3064: To_Number(NULL) customer_product_id,
3065: SI.name,
3066: SI.description,

Line 3088: okc_k_lines_b lin,

3084: lin.price_negotiated,
3085: lin.price_negotiated,
3086: -99 "top_lvl_parent"
3087: FROM okc_k_items itm,
3088: okc_k_lines_b lin,
3089: OKX_SYSTEM_ITEMS_V SI,
3090: okc_statuses_b sts
3091: WHERE lin.id = itm.cle_id
3092: AND lin.dnz_chr_id = p_contract_id

Line 3106: FROM okc_k_lines_b line

3102: To_Char(lin.cle_id),
3103: To_Char(lin.dnz_chr_id),
3104: lin.lse_id,
3105: (SELECT line_number
3106: FROM okc_k_lines_b line
3107: WHERE line.id = lin.cle_id) || '.' || lin.line_number line_number,
3108: To_Number(NULL) customer_product_id,
3109: SI.name,
3110: SI.description,

Line 3132: okc_k_lines_b lin,

3128: lin.price_negotiated,
3129: lin.price_negotiated,
3130: -99 "top_lvl_parent"
3131: FROM okc_k_items itm,
3132: okc_k_lines_b lin,
3133: okx_parties_v SI,
3134: okc_statuses_b sts
3135: WHERE lin.id = itm.cle_id
3136: AND lin.dnz_chr_id = p_contract_id

Line 3150: FROM okc_k_lines_b line

3146: To_Char(lin.cle_id),
3147: To_Char(lin.dnz_chr_id),
3148: lin.lse_id,
3149: (SELECT line_number
3150: FROM okc_k_lines_b line
3151: WHERE line.id = lin.cle_id) || '.' || lin.line_number line_number,
3152: To_Number(NULL) customer_product_id,
3153: SI.party_site_number || '-' || NVL(SI.name, ' '),
3154: SI.description,

Line 3176: okc_k_lines_b lin,

3172: lin.price_negotiated,
3173: lin.price_negotiated,
3174: -99 "top_lvl_parent"
3175: FROM okc_k_items itm,
3176: okc_k_lines_b lin,
3177: okx_party_sites_v SI,
3178: okc_statuses_b sts
3179: WHERE lin.id = itm.cle_id
3180: AND lin.dnz_chr_id = p_contract_id

Line 3194: FROM okc_k_lines_b line

3190: To_Char(lin.cle_id),
3191: To_Char(lin.dnz_chr_id),
3192: lin.lse_id,
3193: (SELECT line_number
3194: FROM okc_k_lines_b line
3195: WHERE line.id = lin.cle_id) || '.' || lin.line_number line_number,
3196: To_Number(NULL) customer_product_id,
3197: SI.name,
3198: SI.description,

Line 3220: okc_k_lines_b lin,

3216: lin.price_negotiated,
3217: lin.price_negotiated,
3218: -99 "top_lvl_parent"
3219: FROM okc_k_items itm,
3220: okc_k_lines_b lin,
3221: okx_systems_v SI,
3222: okc_statuses_b sts,
3223: CSI_SYSTEMS_TL CSTL
3224: WHERE lin.id = itm.cle_id

Line 3241: FROM okc_k_lines_b line

3237: To_Char(lin.cle_id),
3238: To_Char(lin.dnz_chr_id),
3239: lin.lse_id,
3240: (SELECT line_number
3241: FROM okc_k_lines_b line
3242: WHERE line.id = lin.cle_id) || '.' || lin.line_number line_number,
3243: To_Number(NULL) customer_product_id,
3244: DECODE(c.account_name, NULL, p.party_name, c.account_name) name,
3245: c.account_number description,

Line 3267: okc_k_lines_b lin,

3263: lin.price_negotiated,
3264: lin.price_negotiated,
3265: -99 "top_lvl_parent"
3266: FROM okc_k_items itm,
3267: okc_k_lines_b lin,
3268: hz_cust_accounts c,
3269: hz_parties p,
3270: okc_statuses_b sts
3271: WHERE p.party_id = c.party_id

Line 3294: FROM okc_k_lines_b line

3290: lin.id,
3291: lin.cle_id,
3292: lin.dnz_chr_id,
3293: (SELECT line_number
3294: FROM okc_k_lines_b line
3295: WHERE line.id = lin.cle_id) || '.' || lin.line_number line_number,
3296: cs_item.customer_product_id,
3297: SI.name,
3298: SI.description,

Line 3322: okc_k_lines_b lin,

3318: END top_lvl_parent,
3319: 'N',
3320: 'N'
3321: FROM okc_k_items itm,
3322: okc_k_lines_b lin,
3323: OKX_SYSTEM_ITEMS_V SI,
3324: oks_ib_config_v cs_item,
3325: okc_statuses_b sts
3326: WHERE itm.object1_id1 = cs_item.customer_product_id

Line 3333: FROM okc_k_lines_b line

3329: AND SI.id1 = cs_item.INVENTORY_ITEM_ID
3330: AND SI.ORGANIZATION_ID = cs_item.inv_master_organization_id
3331: AND lin.sts_code = sts.code
3332: ORDER BY To_Number((SELECT line_number
3333: FROM okc_k_lines_b line
3334: WHERE line.id = lin.cle_id)),To_Number(lin.line_number); */
3335:
3336: UPDATE oks_sublines_temp
3337: SET top_lvl_parent = -99

Line 3456: FROM oks_sublines_temp tmp, okc_k_lines_b lin

3452: FROM okc_statuses_b sts
3453: WHERE sts.code = lin.sts_code),
3454: 'N',
3455: 'Y') status_change
3456: FROM oks_sublines_temp tmp, okc_k_lines_b lin
3457: WHERE tmp.id = lin.id
3458: AND tmp.dnz_chr_id = p_contract_id;
3459:
3460:

Line 3471: FROM oks_lines_temp tmp, okc_k_lines_b lin

3467: FROM okc_statuses_b sts
3468: WHERE sts.code = lin.sts_code),
3469: 'N',
3470: 'Y') status_change
3471: FROM oks_lines_temp tmp, okc_k_lines_b lin
3472: WHERE tmp.id = lin.id
3473: AND tmp.dnz_chr_id = p_contract_id;
3474:
3475: CURSOR c_get_error_records IS