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

Line 29: --| okc_k_headers_all_b | X | | X | | | |

25: --| OKC_K_VERS_NUMBERS | X | | X | | | |
26: --+---------------------------------+---+---+---+---+---+----------------------+
27: --| FND_ATTACHED_DOCUMENTS | | | | | |X |
28: --+---------------------------------+---+---+---+---+---+----------------------+
29: --| okc_k_headers_all_b | X | | X | | | |
30: --+---------------------------------+---+---+---+---+---+----------------------+
31: --| JTF_NOTES_PUB | | | | | |X |
32: --+---------------------------------+---+---+---+---+---+----------------------+
33: --| JTF_NOTES_VL | X | | | | | |

Line 1086: FROM okc_k_headers_all_b

1082:
1083: CURSOR l_chr_csr
1084: IS
1085: SELECT application_id
1086: FROM okc_k_headers_all_b
1087: WHERE ID = p_chr_id;
1088: BEGIN
1089: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1090: THEN

Line 1426: FROM okc_k_headers_all_b

1422:
1423: CURSOR l_chr_csr2
1424: IS
1425: SELECT 'x'
1426: FROM okc_k_headers_all_b
1427: WHERE contract_number = p_contract_number
1428: AND contract_number_modifier = p_contract_number_modifier;
1429:
1430: l_found BOOLEAN := FALSE;

Line 1865: FROM okc_k_headers_all_b where id = contract_id ) oks_id,

1861: kh.contract_number contract_number,
1862: kh.contract_number_modifier,
1863: get_modifier(temp.contract_id),
1864: (SELECT okc_p_util.raw_to_number (SYS_GUID ())
1865: FROM okc_k_headers_all_b where id = contract_id ) oks_id,
1866: ks.price_uom
1867:
1868: FROM okc_k_headers_all_b kh,
1869: oks_k_headers_b ks,

Line 1868: FROM okc_k_headers_all_b kh,

1864: (SELECT okc_p_util.raw_to_number (SYS_GUID ())
1865: FROM okc_k_headers_all_b where id = contract_id ) oks_id,
1866: ks.price_uom
1867:
1868: FROM okc_k_headers_all_b kh,
1869: oks_k_headers_b ks,
1870: oks_instance_k_dtls_temp temp,
1871: okc_statuses_b st,
1872: okc_governances gov

Line 3293: okc_k_headers_all_b kh

3289: okc_k_lines_b kl,
3290: okc_k_items itm,
3291: oks_k_lines_v ks,
3292: okc_statuses_b st,
3293: okc_k_headers_all_b kh
3294: WHERE temp.topline_id = kl.ID
3295: AND temp.new_serviceline_id IS NOT NULL
3296: AND itm.cle_id = kl.ID
3297: AND itm.jtot_object1_code IN ('OKX_WARRANTY', 'OKX_SERVICE')

Line 4520: , Okc_k_headers_all_b Kh

4516: ,Kh.qcl_id
4517: ,oKh.start_date
4518: ,ks.period_start
4519: From OKs_instance_k_dtls_temp temp
4520: , Okc_k_headers_all_b Kh
4521: , Okc_k_headers_all_b OKH
4522: , Okc_statuses_b St
4523: , Okc_statuses_b OSt
4524: , Okc_k_lines_b Kl

Line 4521: , Okc_k_headers_all_b OKH

4517: ,oKh.start_date
4518: ,ks.period_start
4519: From OKs_instance_k_dtls_temp temp
4520: , Okc_k_headers_all_b Kh
4521: , Okc_k_headers_all_b OKH
4522: , Okc_statuses_b St
4523: , Okc_statuses_b OSt
4524: , Okc_k_lines_b Kl
4525: , Oks_k_headers_b Ks

Line 5097: UPDATE okc_k_headers_all_b

5093: l_ste_code,
5094: l_sts_code
5095: );
5096:
5097: UPDATE okc_k_headers_all_b
5098: SET sts_code = l_sts_code,
5099: date_approved = NULL,
5100: date_signed = NULL
5101: WHERE ID = qa_contract_id ;

Line 5941: , Okc_k_headers_all_b Kh

5937: , kh.inv_organization_id
5938: , St.ste_code
5939: , Kh.start_date
5940: From OKs_instance_k_dtls_temp temp
5941: , Okc_k_headers_all_b Kh
5942: , Okc_statuses_b St
5943: Where Kh.Id = temp.contract_id
5944: And St.code = Kh.sts_code;
5945: contract_id okc_datatypes.numbertabtyp;

Line 6137: okc_k_headers_all_b kh,

6133: NVL(P_credit_option
6134: ,OKS_IB_UTIL_PVT.get_credit_option(party.object1_id1,kh.authoring_org_id,tmp.transaction_date)),
6135: Kh.inv_organization_id
6136: FROM okc_k_items ki,
6137: okc_k_headers_all_b kh,
6138: oks_k_headers_b ks,
6139: okc_k_lines_b kl,
6140: okc_statuses_b st,
6141: okc_statuses_b Hst,

Line 6228: okc_k_headers_all_b kh,

6224: ,OKS_IB_UTIL_PVT.get_credit_option(party.object1_id1,kh.authoring_org_id,tmp.transaction_date)),
6225: Kh.inv_organization_id
6226:
6227: FROM okc_k_items ki,
6228: okc_k_headers_all_b kh,
6229: oks_k_headers_b ks,
6230: okc_k_lines_b sl,
6231: okc_k_lines_b Tl,
6232: oks_k_lines_b okl,

Line 6308: okc_k_headers_all_b kh,

6304: NVL(P_credit_option
6305: ,OKS_IB_UTIL_PVT.get_credit_option(party.object1_id1,kh.authoring_org_id,tmp.transaction_date)),
6306: Kh.inv_organization_id
6307: FROM okc_k_items ki,
6308: okc_k_headers_all_b kh,
6309: okc_k_lines_b kl,
6310: okc_statuses_b st,
6311: oks_instance_temp tmp,
6312: okc_k_lines_b tl,

Line 6372: okc_k_headers_all_b kh,

6368:
6369:
6370:
6371: FROM okc_k_items ki,
6372: okc_k_headers_all_b kh,
6373: okc_k_lines_b kl,
6374: okc_k_lines_b tl,
6375: okc_statuses_b st,
6376: csi_counter_associations ctrAsc,

Line 6441: okc_k_headers_all_b kh,

6437:
6438:
6439:
6440: FROM okc_k_items ki,
6441: okc_k_headers_all_b kh,
6442: okc_k_lines_b kl,
6443: okc_statuses_b st,
6444: oks_instance_temp tmp,
6445: okc_k_lines_b tl,

Line 6535: FROM okc_k_headers_all_b

6531: p_id NUMBER
6532: )
6533: IS
6534: SELECT qcl_id
6535: FROM okc_k_headers_all_b
6536: WHERE ID = p_id;
6537:
6538: CURSOR check_relation_csr
6539: IS

Line 6579: FROM okc_k_headers_all_b

6575: )
6576: IS
6577: SELECT b.ID,
6578: (SELECT start_date
6579: FROM okc_k_headers_all_b
6580: WHERE ID = new_contract_id),
6581: (SELECT end_date
6582: FROM okc_k_headers_all_b
6583: WHERE ID = new_contract_id),

Line 6582: FROM okc_k_headers_all_b

6578: (SELECT start_date
6579: FROM okc_k_headers_all_b
6580: WHERE ID = new_contract_id),
6581: (SELECT end_date
6582: FROM okc_k_headers_all_b
6583: WHERE ID = new_contract_id),
6584: (SELECT sts_code
6585: FROM okc_k_headers_all_b
6586: WHERE ID = new_contract_id),

Line 6585: FROM okc_k_headers_all_b

6581: (SELECT end_date
6582: FROM okc_k_headers_all_b
6583: WHERE ID = new_contract_id),
6584: (SELECT sts_code
6585: FROM okc_k_headers_all_b
6586: WHERE ID = new_contract_id),
6587: (SELECT start_date
6588: FROM okc_k_lines_b
6589: WHERE ID = new_serviceline_id),

Line 6662: , Okc_k_headers_all_b Kh

6658: , kh.authoring_org_id
6659: , kh.inv_organization_id
6660: , St.ste_code
6661: From OKs_instance_k_dtls_temp temp
6662: , Okc_k_headers_all_b Kh
6663: , Okc_statuses_b St
6664: Where Kh.Id = temp.contract_id
6665: And St.code = Kh.sts_code;
6666:

Line 7301: okc_k_headers_all_b hdr

7297: lines_b.date_cancelled, --Date cancelled,
7298: 'TERM'
7299: from oks_instance_history ins_hist,
7300: Okc_k_lines_b lines_b,
7301: okc_k_headers_all_b hdr
7302: Where ins_hist.batch_id = p_batch_id
7303: and instance_id = custprod_id(i) and lines_b.id = subline_id (i)
7304: And hdr.id =contract_id (i) ) ;
7305:

Line 7561: UPDATE okc_k_headers_all_b

7557: fnd_file.put_line(fnd_file.log,'(OKS) -> Topline amounts updated successfully');
7558:
7559: -- Update the contract amount
7560: FORALL i IN 1 .. new_contract_id.COUNT
7561: UPDATE okc_k_headers_all_b
7562: SET estimated_amount =
7563: (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0)
7564: FROM okc_k_lines_b
7565: WHERE dnz_chr_id = new_contract_id (i)

Line 7686: Update okc_k_headers_all_b set date_renewed = l_line_date_renewed

7682: Where id = (select cle_id from okc_k_lines_b where id = l_object_line_id)
7683: And date_renewed Is Null;
7684:
7685: l_hdr_date_renewed := OKS_IB_UTIL_PVT.Check_renewed_lines(l_object_line_id);
7686: Update okc_k_headers_all_b set date_renewed = l_line_date_renewed
7687: Where id = (select dnz_chr_id from okc_k_lines_b where id = l_object_line_id)
7688: And date_renewed Is Null;
7689:
7690:

Line 7820: ,okc_k_headers_all_b hdr

7816: SYSDATE,
7817: fnd_global.login_id,
7818: line.date_cancelled --Date cancelled
7819: from Oks_instance_history inshist, Okc_k_lines_b line
7820: ,okc_k_headers_all_b hdr
7821: Where inshist.instance_id = custprod_id(i)
7822: and batch_id = p_batch_id
7823: And line.id = subline_id(i)
7824: And hdr.id = contract_id(i)

Line 7922: , okc_k_headers_all_b hdr

7918: fnd_global.user_id,
7919: SYSDATE,
7920: fnd_global.login_id
7921: from Oks_instance_history inshist
7922: , okc_k_headers_all_b hdr
7923: , okc_k_lines_b line
7924: , okc_k_lines_b subline
7925: Where inshist.instance_id = custprod_id(i)
7926: and batch_id = p_batch_id

Line 8110: UPDATE okc_k_headers_all_b

8106: Hdr_new_edate;
8107: Close l_Contract_csr;
8108:
8109: FORALL i IN 1 .. header_id.COUNT
8110: UPDATE okc_k_headers_all_b
8111: SET start_date = Hdr_new_Sdate(i),
8112: end_date = Hdr_new_edate(i),
8113: sts_code = get_status (Hdr_new_Sdate(i), Hdr_new_edate(i)),
8114: last_updated_by = fnd_global.user_id,

Line 8317: FROM oks_instance_history a, Okc_k_headers_all_b hdr

8313: fnd_global.user_id,
8314: SYSDATE,
8315: fnd_global.login_id,
8316: null
8317: FROM oks_instance_history a, Okc_k_headers_all_b hdr
8318: , okc_k_lines_b line
8319: , okc_k_lines_b subline
8320: WHERE a.batch_id = p_batch_id
8321: AND a.transaction_type = 'IDC'

Line 8654: Okc_k_headers_all_b hdr

8650: fnd_global.login_id,
8651: line.date_cancelled
8652: FROM oks_instance_history a,
8653: Okc_k_lines_b line,
8654: Okc_k_headers_all_b hdr
8655: WHERE a.batch_id = p_batch_id
8656: AND a.transaction_type = 'TRM'
8657: AND a.instance_id = custprod_id(i)
8658: AND line.id = subline_id(i)