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_IB_UTIL_PVT dependencies on OKS_INSTANCE_K_DTLS_TEMP

Line 195: FROM Oks_Instance_k_dtls_temp

191: IS
192: CURSOR get_hdr_temp_count
193: IS
194: SELECT COUNT (*)
195: FROM Oks_Instance_k_dtls_temp
196: WHERE contract_id = p_id;
197:
198: CURSOR get_line_temp_count
199: IS

Line 201: FROM Oks_Instance_k_dtls_temp

197:
198: CURSOR get_line_temp_count
199: IS
200: SELECT COUNT (*)
201: FROM Oks_Instance_k_dtls_temp
202: WHERE topline_id = p_id;
203:
204: CURSOR get_hdr_count
205: IS

Line 855: From Okc_k_headers_all_b okc, Oks_Instance_k_dtls_temp tmp

851:
852:
853: Cursor get_ou_csr Is
854: Select distinct(okc.authoring_org_id) org_id
855: From Okc_k_headers_all_b okc, Oks_Instance_k_dtls_temp tmp
856: where tmp.Contract_id = okc.Id
857: And tmp.Parent_id = p_batch_Id;
858:
859: Cursor l_party_csr Is

Line 1433: , Oks_Instance_k_dtls_temp tmp

1429: From OKC_K_ITEMS KI
1430: , OKC_K_HEADERS_all_B KH
1431: , OKC_K_LINES_B KL
1432: , OKC_STATUSES_B ST
1433: , Oks_Instance_k_dtls_temp tmp
1434: , OKS_K_LINES_B KS
1435: , OKS_K_LINES_B KS1
1436: ,OKC_STATUSES_B HST
1437:

Line 1488: , Oks_Instance_k_dtls_temp tmp

1484: From OKC_K_ITEMS KI
1485: , OKC_K_HEADERS_ALL_B KH
1486: , OKC_K_LINES_B KL
1487: , OKC_STATUSES_B ST
1488: , Oks_Instance_k_dtls_temp tmp
1489: , OKC_STATUSES_B HST
1490: Where tmp.parent_id = p_batch_id
1491: And KI.Object1_id1 = to_char(tmp.instance_id)
1492: And KI.Jtot_Object1_code = 'OKX_CUSTPROD'

Line 1541: , Oks_Instance_k_dtls_temp tmp

1537: ,OKC_K_HEADERS_ALL_B KH
1538: ,OKC_K_LINES_B KL
1539: ,OKC_STATUSES_B ST
1540: ,csi_counter_associations ctrAsc
1541: , Oks_Instance_k_dtls_temp tmp
1542: , OKC_STATUSES_B HST
1543:
1544: Where tmp.parent_id = p_batch_id
1545: And KI.object1_id1 = to_char(ctrAsc.Counter_id)

Line 1596: , Oks_Instance_k_dtls_temp tmp

1592: , OKC_K_LINES_B KL
1593: , OKC_STATUSES_B ST
1594: , OKS_K_LINES_B KS
1595: , Oks_k_lines_b KS1
1596: , Oks_Instance_k_dtls_temp tmp
1597: Where tmp.parent_id = p_batch_id
1598: And KI.Object1_id1 = to_char(tmp.instance_id)
1599: And KI.Jtot_Object1_code = 'OKX_CUSTPROD'
1600: And KI.dnz_chr_id = KH.ID

Line 1696: Delete Oks_Instance_k_dtls_temp ;

1692: For i in l_item_instance_tbl.first ..l_item_instance_tbl.last
1693: Loop
1694: If l_item_instance_tbl(i).transaction_type = 'TRF' Then
1695:
1696: Delete Oks_Instance_k_dtls_temp ;
1697: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1698: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.POPULATE_GLOBAL_TEMP',
1699: 'Insert inot temp ');
1700:

Line 1703: INSERT INTO Oks_Instance_k_dtls_temp

1699: 'Insert inot temp ');
1700:
1701: End If;
1702: FORALL j in l_item_instance_tbl(i).instance_tbl.first..l_item_instance_tbl(i).instance_tbl.last
1703: INSERT INTO Oks_Instance_k_dtls_temp
1704: (
1705: parent_id ,
1706: subline_id,
1707: topline_id ,

Line 1754: Delete Oks_Instance_k_dtls_temp ;

1750: For i in l_item_instance_tbl.first ..l_item_instance_tbl.last
1751: Loop
1752: If l_item_instance_tbl(i).transaction_type = 'TRM' Then
1753:
1754: Delete Oks_Instance_k_dtls_temp ;
1755:
1756: FORALL j in l_item_instance_tbl(i).instance_tbl.first..l_item_instance_tbl(i).instance_tbl.last
1757: INSERT INTO Oks_Instance_k_dtls_temp
1758: (

Line 1757: INSERT INTO Oks_Instance_k_dtls_temp

1753:
1754: Delete Oks_Instance_k_dtls_temp ;
1755:
1756: FORALL j in l_item_instance_tbl(i).instance_tbl.first..l_item_instance_tbl(i).instance_tbl.last
1757: INSERT INTO Oks_Instance_k_dtls_temp
1758: (
1759: parent_id ,
1760: subline_id,
1761: topline_id ,

Line 1806: Delete Oks_Instance_k_dtls_temp ;

1802: Else
1803: For i in l_item_instance_tbl.first ..l_item_instance_tbl.last
1804: Loop
1805: If l_item_instance_tbl(i).transaction_type = 'IDC' Then
1806: Delete Oks_Instance_k_dtls_temp ;
1807:
1808: FORALL j in l_item_instance_tbl(i).instance_tbl.first..l_item_instance_tbl(i).instance_tbl.last
1809: INSERT INTO Oks_Instance_k_dtls_temp
1810: (

Line 1809: INSERT INTO Oks_Instance_k_dtls_temp

1805: If l_item_instance_tbl(i).transaction_type = 'IDC' Then
1806: Delete Oks_Instance_k_dtls_temp ;
1807:
1808: FORALL j in l_item_instance_tbl(i).instance_tbl.first..l_item_instance_tbl(i).instance_tbl.last
1809: INSERT INTO Oks_Instance_k_dtls_temp
1810: (
1811: parent_id ,
1812: subline_id,
1813: topline_id ,

Line 1859: Delete Oks_Instance_k_dtls_temp;-- where parent_id = p_batch_id;

1855: End If;
1856:
1857: End If;
1858:
1859: Delete Oks_Instance_k_dtls_temp;-- where parent_id = p_batch_id;
1860: If Subline_tbl.count > 0 Then
1861: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1862: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.POPULATE_GLOBAL_TEMP',
1863: 'Subline_tbl.count = ' ||Subline_tbl.count );

Line 1868: INSERT INTO Oks_Instance_k_dtls_temp

1864:
1865: End If;
1866:
1867: FORALL i in Subline_tbl.FIRST..Subline_tbl.LAST
1868: INSERT INTO Oks_Instance_k_dtls_temp
1869: (
1870: parent_id ,
1871: subline_id,
1872: topline_id ,

Line 2402: FROM oks_Instance_k_dtls_temp temp

2398:
2399: CURSOR get_line_term
2400: IS
2401: SELECT max(date_terminated)
2402: FROM oks_Instance_k_dtls_temp temp
2403: where topline_id = p_Line_id
2404: having count(*) = (select count(*) from Okc_k_lines_b
2405: WHERE cle_id = p_line_id AND lse_id IN (8,7,9,10,11,13,35, 18, 25)
2406: );

Line 2412: FROM oks_Instance_k_dtls_temp temp

2408:
2409: CURSOR get_max_line_term
2410: IS
2411: SELECT max(date_terminated)
2412: FROM oks_Instance_k_dtls_temp temp
2413: where topline_id = p_Line_id;
2414:
2415:
2416:

Line 2422: And line.id not in (select subline_id from oks_instance_k_dtls_temp where topline_id = p_line_id)

2418: Select max(line.date_terminated)
2419: From OKC_K_LINES_B line
2420: Where line.cle_id= p_line_id
2421: and line.lse_id in (8,7,9,10,11,13,18,25,35)
2422: And line.id not in (select subline_id from oks_instance_k_dtls_temp where topline_id = p_line_id)
2423: having Count(line.id) = count(decode(line.date_terminated, null, null, 'x'));
2424:
2425:
2426:

Line 2430: FROM oks_Instance_k_dtls_temp

2426:
2427: CURSOR get_Hdr_term
2428: IS
2429: SELECT max(date_terminated)
2430: FROM oks_Instance_k_dtls_temp
2431: where contract_id = p_Line_id
2432: having count(*) = (select count(*) from Okc_k_lines_b
2433: WHERE dnz_chr_id= p_line_id AND lse_id IN (8,7,9,10,11,13,35, 18, 25)
2434: );

Line 2441: FROM oks_Instance_k_dtls_temp temp

2437:
2438: CURSOR get_max_Hdr_term
2439: IS
2440: SELECT max(date_terminated)
2441: FROM oks_Instance_k_dtls_temp temp
2442: where Contract_id = p_Line_id;
2443:
2444:
2445:

Line 2452: And line.id not in (select subline_id from oks_instance_k_dtls_temp where Contract_id = p_line_id)

2448: Select max(line.date_terminated)
2449: From OKC_K_LINES_B line
2450: Where line.dnz_chr_id= p_line_id
2451: and line.lse_id in (8,7,9,10,11,13,18,25,35)
2452: And line.id not in (select subline_id from oks_instance_k_dtls_temp where Contract_id = p_line_id)
2453: having Count(*) = count(decode(line.date_terminated, null, null, 'x'));
2454:
2455: l_line_date Date;
2456: l_Hdr_date Date;