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 470: FROM okc_K_Headers_all_b h, --mmadhavi MOAC - changed to _ALL_B for performance

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

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

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

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

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

Line 1328: FROM okc_K_Headers_all_b h,

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

Line 1681: FROM okc_k_headers_all_b

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

Line 1749: SELECT org_id FROM okc_k_headers_all_b WHERE

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

Line 1844: okc_k_headers_all_b chr,

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

Line 1886: FROM okc_k_headers_all_b

1882:
1883:
1884: CURSOR set_org(p_header_id IN NUMBER) IS
1885: SELECT inv_organization_id, org_id, currency_code --mmadhavi changed to Org_id for MOAC
1886: FROM okc_k_headers_all_b
1887: WHERE id = p_header_id;
1888:
1889: -- 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
1890: -- anyway

Line 1907: FROM okc_K_Headers_all_b h,

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

Line 2694: UPDATE okc_k_headers_all_b h SET

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

Line 3008: UPDATE okc_k_headers_all_b h

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