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_RENCON_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 173: FROM okc_K_Headers_all_b h, --mmadhavi MOAC - changed to _ALL_B for performance

169: h.org_id, --mmadhavi MOAC : changed to org_id
170: h.inv_organization_id,
171: pr.object1_id1,
172: h.currency_code
173: FROM okc_K_Headers_all_b h, --mmadhavi MOAC - changed to _ALL_B for performance
174: okc_k_party_roles_b pr,
175: okc_k_party_roles_b pr1,
176: okc_statuses_b st
177: WHERE h.id = p_target_id

Line 248: FROM okc_K_Headers_all_b h, --mmadhavi MOAC - changed to _ALL_B for performance

244:
245: -- Added for bug # 2870380
246: CURSOR get_correct_status(l_source_chr_id IN NUMBER, l_source_subline_id IN NUMBER) IS
247: SELECT h.id
248: FROM okc_K_Headers_all_b h, --mmadhavi MOAC - changed to _ALL_B for performance
249: okc_k_party_roles_b pr,
250: okc_statuses_b st
251: , okc_k_lines_b s
252: WHERE h.id = l_source_chr_id

Line 469: FROM okc_K_Headers_all_b h, --mmadhavi MOAC - changed to _ALL_B for performance

465: h.org_id, --mmadhavi MOAC : changed to org_id
466: h.inv_organization_id,
467: pr.object1_id1,
468: h.currency_code
469: FROM okc_K_Headers_all_b h, --mmadhavi MOAC - changed to _ALL_B for performance
470: okc_k_party_roles_b pr,
471: okc_k_party_roles_b pr1,
472: okc_statuses_b st
473: WHERE h.id = p_target_id

Line 494: FROM okc_K_Headers_all_b h, --mmadhavi MOAC - changed to _ALL_B for performance

490:
491: CURSOR valid_header_sources(p_target_id IN NUMBER) IS
492: SELECT
493: h.id
494: FROM okc_K_Headers_all_b h, --mmadhavi MOAC - changed to _ALL_B for performance
495: okc_k_party_roles_b pr,
496: okc_statuses_b st
497: WHERE h.scs_code IN ('WARRANTY', x_scs_code)
498: AND h.chr_type = x_chr_type

Line 517: FROM okc_K_Headers_all_b h, --mmadhavi MOAC - changed to _ALL_B for performance

513: -- Use this cursor only if the target contract currency is EUR
514: CURSOR valid_header_sources_eur(p_target_id IN NUMBER) IS
515: SELECT
516: h.id
517: FROM okc_K_Headers_all_b h, --mmadhavi MOAC - changed to _ALL_B for performance
518: okc_k_party_roles_b pr,
519: okc_statuses_b st
520: WHERE h.scs_code IN ('WARRANTY', x_scs_code)
521: AND h.chr_type = x_chr_type

Line 1327: FROM okc_K_Headers_all_b h,

1323:
1324: CURSOR valid_target (p_target_id IN NUMBER) IS
1325: SELECT
1326: 'X'
1327: FROM okc_K_Headers_all_b h,
1328: okc_k_party_roles_b pr,
1329: okc_k_party_roles_b pr1,
1330: okc_statuses_b st
1331: WHERE h.id = p_target_id

Line 1680: FROM okc_k_headers_all_b

1676:
1677: FUNCTION GET_CURRENCY(p_chr_id IN NUMBER) RETURN VARCHAR2 IS
1678: CURSOR source_currency IS
1679: SELECT currency_code
1680: FROM okc_k_headers_all_b
1681: WHERE id = p_chr_id;
1682: x_return VARCHAR2(15);
1683: BEGIN
1684: FOR source_currency_rec IN source_currency

Line 1747: SELECT org_id FROM okc_k_headers_all_b WHERE

1743: FUNCTION SUBMIT_FORM_CONC(p_oie_id IN NUMBER) RETURN NUMBER IS
1744:
1745: --added for MOAC changes
1746: CURSOR c_org_id(cp_oie_id IN NUMBER) IS
1747: SELECT org_id FROM okc_k_headers_all_b WHERE
1748: id = (SELECT target_chr_id FROM okc_operation_instances WHERE id = cp_oie_id);
1749:
1750: req_id NUMBER;
1751: l_mode BOOLEAN;

Line 1842: okc_k_headers_all_b chr,

1838: chr.authoring_org_id,
1839: chr.currency_code
1840: FROM okc_operation_lines b,
1841: okc_k_lines_b cle,
1842: okc_k_headers_all_b chr,
1843: okc_statuses_b st
1844: WHERE b.oie_id = p_oie_id
1845: and cle.id = b.object_cle_id
1846: and cle.cle_id is null

Line 1884: FROM okc_k_headers_all_b

1880:
1881:
1882: CURSOR set_org(p_header_id IN NUMBER) IS
1883: SELECT inv_organization_id, org_id, currency_code --mmadhavi changed to Org_id for MOAC
1884: FROM okc_k_headers_all_b
1885: WHERE id = p_header_id;
1886:
1887: -- MSENGUPT 11/07 the following cursor is not needed as it is taken care of in get subline csr as we have to join to okc_k_lines
1888: -- anyway

Line 1905: FROM okc_K_Headers_all_b h,

1901: h.authoring_org_id,
1902: h.inv_organization_id,
1903: pr.object1_id1,
1904: h.currency_code
1905: FROM okc_K_Headers_all_b h,
1906: okc_k_party_roles_b pr,
1907: okc_statuses_b st
1908: WHERE
1909: h.id=pr.dnz_chr_id and pr.cle_id is null

Line 2692: UPDATE okc_k_headers_all_b h SET

2688: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2689: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.update_headers','updating date_renewed for source headers');
2690: END IF;
2691:
2692: UPDATE okc_k_headers_all_b h SET
2693: h.date_renewed = l_date_renewed,
2694: h.object_version_number = h.object_version_number + 1,
2695: h.last_updated_by = l_user_id,
2696: h.last_update_date = l_update_date,

Line 3004: UPDATE okc_k_headers_all_b h

3000: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.top_lines','top lines price_negotiated and tax_amount updated');
3001: END IF;
3002:
3003: --update the header
3004: UPDATE okc_k_headers_all_b h
3005: SET h.estimated_amount =
3006: (SELECT SUM(price_negotiated) FROM okc_k_lines_b tl
3007: WHERE tl.dnz_chr_id = p_header_id AND tl.cle_id IS NULL
3008: AND tl.lse_id IN (1, 12, 19, 46)),