APPS.OKS_IBINT_PUB dependencies on OKS_INSTANCE_TEMP

Line 1180: From Oks_instance_temp

1176: ,Order_line_id
1177: ,Shipped_date
1178: ,Installation_date
1179: ,transaction_date
1180: From Oks_instance_temp
1181: Where New = 'Y';
1182:
1183:
1184:

Line 1269: , OKS_INSTANCE_TEMP tmp

1265: ,OKC_K_PARTY_ROLES_B PARTY
1266: , OKC_K_LINES_B OL
1267: ,OKS_K_LINES_B KSL
1268: ,OKC_K_ITEMS KIS
1269: , OKS_INSTANCE_TEMP tmp
1270:
1271: Where tmp.trf = 'Y'
1272: And nvl(tmp.trm,'N') = 'N'
1273: And KI.Object1_id1 = to_char(tmp.old_customer_product_id)

Line 1371: , OKS_INSTANCE_TEMP tmp

1367: From OKC_K_ITEMS KI
1368: , OKC_K_HEADERS_ALL_B KH
1369: , OKC_K_LINES_B KL
1370: , OKC_STATUSES_B ST
1371: , OKS_INSTANCE_TEMP tmp
1372: , OKC_K_LINES_B TL
1373: ,OKC_K_ITEMS KIS
1374: ,OKC_K_PARTY_ROLES_B PARTY
1375: Where tmp.trm = 'Y'

Line 1476: ,OKS_INSTANCE_TEMP tmp

1472: ,OKC_K_LINES_B KL
1473: ,OKC_K_LINES_B TL
1474: ,OKC_STATUSES_B ST
1475: ,csi_counter_associations CTRASC
1476: ,OKS_INSTANCE_TEMP tmp
1477: ,OKC_K_ITEMS KIS
1478: ,OKC_K_PARTY_ROLES_B PARTY
1479: Where tmp.trm = 'Y'
1480: And KI.object1_id1 = TO_CHAR (CTRASC.Counter_id)

Line 1574: , OKS_INSTANCE_TEMP tmp

1570: From OKC_K_ITEMS KI
1571: , OKC_K_HEADERS_ALL_B KH
1572: , OKC_K_LINES_B KL
1573: , OKC_STATUSES_B ST
1574: , OKS_INSTANCE_TEMP tmp
1575: , OKC_K_LINES_B TL
1576: ,OKC_K_ITEMS KIS
1577: ,OKC_K_PARTY_ROLES_B PARTY
1578:

Line 1678: , OKS_INSTANCE_TEMP tmp

1674: ,OKC_K_LINES_B KL
1675: ,OKC_K_LINES_B TL
1676: ,OKC_STATUSES_B ST
1677: ,csi_counter_associations CTRASC
1678: , OKS_INSTANCE_TEMP tmp
1679: ,OKC_K_ITEMS KIS
1680: ,OKC_K_PARTY_ROLES_B PARTY
1681:
1682: Where tmp.ret = 'Y'

Line 1779: , OKS_INSTANCE_TEMP tmp

1775: From OKC_K_ITEMS KI
1776: , OKC_K_HEADERS_ALL_B KH
1777: , OKC_K_LINES_B KL
1778: , OKC_STATUSES_B ST
1779: , OKS_INSTANCE_TEMP tmp
1780: , OKC_K_LINES_B TL
1781: ,OKC_K_ITEMS KIS
1782: Where tmp.idc = 'Y'
1783: And nvl(tmp.trm,'N') = 'N'

Line 1856: , OKS_INSTANCE_TEMP tmp

1852: From OKC_K_ITEMS KI
1853: , OKC_K_HEADERS_ALL_B KH
1854: , OKC_K_LINES_v KL
1855: , OKC_STATUSES_B ST
1856: , OKS_INSTANCE_TEMP tmp
1857: , OKC_K_LINES_B TL
1858: ,OKC_K_ITEMS KIS
1859: , OKS_K_LINES_B OKL
1860: Where tmp.spl = 'Y'

Line 1937: , OKS_INSTANCE_TEMP tmp

1933: From OKC_K_ITEMS KI
1934: , OKC_K_HEADERS_ALL_B KH
1935: , OKC_K_LINES_v KL
1936: , OKC_STATUSES_B ST
1937: , OKS_INSTANCE_TEMP tmp
1938: , OKC_K_LINES_B TL
1939: ,OKC_K_ITEMS KIS
1940: , OKS_K_LINES_B OKL
1941:

Line 2018: , OKS_INSTANCE_TEMP tmp

2014: From OKC_K_ITEMS KI
2015: , OKC_K_HEADERS_ALL_B KH
2016: , OKC_K_LINES_B KL
2017: , OKC_STATUSES_B ST
2018: , OKS_INSTANCE_TEMP tmp
2019: , OKC_K_LINES_B TL
2020: , OKC_K_ITEMS KIS
2021: , OKS_K_LINES_B OKL
2022: Where tmp.upd = 'Y'

Line 2042: From Oks_subscr_header_b oks, Oks_instance_temp tmp

2038: OR (trunc(tmp.transaction_date) <= trunc(kl.start_date)) );
2039:
2040: Cursor check_subscription_instance Is
2041: Select 'Y'
2042: From Oks_subscr_header_b oks, Oks_instance_temp tmp
2043: Where oks.instance_id = tmp.old_customer_product_id;
2044:
2045: Cursor l_refnum_csr(p_cp_id NUMBER) IS
2046: select instance_number

Line 2090: Delete from Oks_Instance_temp;

2086: l_org_id := MO_GLOBAL.Get_current_org_id;
2087:
2088: MO_Global.set_policy_context('A', null);
2089:
2090: Delete from Oks_Instance_temp;
2091:
2092: FORALL i in P_oks_txn_inst_tbl.FIRST..P_oks_txn_inst_tbl.LAST
2093: INSERT INTO oks_instance_temp
2094: Values P_oks_txn_inst_tbl(i);

Line 2093: INSERT INTO oks_instance_temp

2089:
2090: Delete from Oks_Instance_temp;
2091:
2092: FORALL i in P_oks_txn_inst_tbl.FIRST..P_oks_txn_inst_tbl.LAST
2093: INSERT INTO oks_instance_temp
2094: Values P_oks_txn_inst_tbl(i);
2095:
2096: --If instance is a subscription instance throw an error
2097: Open check_subscription_instance;