APPS.OKS_IBINT_PUB dependencies on OKS_INSTANCE_TEMP

Line 1160: From Oks_instance_temp

1156: ,Order_line_id
1157: ,Shipped_date
1158: ,Installation_date
1159: ,transaction_date
1160: From Oks_instance_temp
1161: Where New = 'Y';
1162:
1163:
1164:

Line 1249: , OKS_INSTANCE_TEMP tmp

1245: ,OKC_K_PARTY_ROLES_B PARTY
1246: , OKC_K_LINES_B OL
1247: ,OKS_K_LINES_B KSL
1248: ,OKC_K_ITEMS KIS
1249: , OKS_INSTANCE_TEMP tmp
1250:
1251: Where tmp.trf = 'Y'
1252: And nvl(tmp.trm,'N') = 'N'
1253: And KI.Object1_id1 = to_char(tmp.old_customer_product_id)

Line 1351: , OKS_INSTANCE_TEMP tmp

1347: From OKC_K_ITEMS KI
1348: , OKC_K_HEADERS_ALL_B KH
1349: , OKC_K_LINES_B KL
1350: , OKC_STATUSES_B ST
1351: , OKS_INSTANCE_TEMP tmp
1352: , OKC_K_LINES_B TL
1353: ,OKC_K_ITEMS KIS
1354: ,OKC_K_PARTY_ROLES_B PARTY
1355: Where tmp.trm = 'Y'

Line 1456: ,OKS_INSTANCE_TEMP tmp

1452: ,OKC_K_LINES_B KL
1453: ,OKC_K_LINES_B TL
1454: ,OKC_STATUSES_B ST
1455: ,csi_counter_associations CTRASC
1456: ,OKS_INSTANCE_TEMP tmp
1457: ,OKC_K_ITEMS KIS
1458: ,OKC_K_PARTY_ROLES_B PARTY
1459: Where tmp.trm = 'Y'
1460: And KI.object1_id1 = TO_CHAR (CTRASC.Counter_id)

Line 1554: , OKS_INSTANCE_TEMP tmp

1550: From OKC_K_ITEMS KI
1551: , OKC_K_HEADERS_ALL_B KH
1552: , OKC_K_LINES_B KL
1553: , OKC_STATUSES_B ST
1554: , OKS_INSTANCE_TEMP tmp
1555: , OKC_K_LINES_B TL
1556: ,OKC_K_ITEMS KIS
1557: ,OKC_K_PARTY_ROLES_B PARTY
1558:

Line 1658: , OKS_INSTANCE_TEMP tmp

1654: ,OKC_K_LINES_B KL
1655: ,OKC_K_LINES_B TL
1656: ,OKC_STATUSES_B ST
1657: ,csi_counter_associations CTRASC
1658: , OKS_INSTANCE_TEMP tmp
1659: ,OKC_K_ITEMS KIS
1660: ,OKC_K_PARTY_ROLES_B PARTY
1661:
1662: Where tmp.ret = 'Y'

Line 1759: , OKS_INSTANCE_TEMP tmp

1755: From OKC_K_ITEMS KI
1756: , OKC_K_HEADERS_ALL_B KH
1757: , OKC_K_LINES_B KL
1758: , OKC_STATUSES_B ST
1759: , OKS_INSTANCE_TEMP tmp
1760: , OKC_K_LINES_B TL
1761: ,OKC_K_ITEMS KIS
1762: Where tmp.idc = 'Y'
1763: And nvl(tmp.trm,'N') = 'N'

Line 1836: , OKS_INSTANCE_TEMP tmp

1832: From OKC_K_ITEMS KI
1833: , OKC_K_HEADERS_ALL_B KH
1834: , OKC_K_LINES_v KL
1835: , OKC_STATUSES_B ST
1836: , OKS_INSTANCE_TEMP tmp
1837: , OKC_K_LINES_B TL
1838: ,OKC_K_ITEMS KIS
1839: , OKS_K_LINES_B OKL
1840: Where tmp.spl = 'Y'

Line 1917: , OKS_INSTANCE_TEMP tmp

1913: From OKC_K_ITEMS KI
1914: , OKC_K_HEADERS_ALL_B KH
1915: , OKC_K_LINES_v KL
1916: , OKC_STATUSES_B ST
1917: , OKS_INSTANCE_TEMP tmp
1918: , OKC_K_LINES_B TL
1919: ,OKC_K_ITEMS KIS
1920: , OKS_K_LINES_B OKL
1921:

Line 1998: , OKS_INSTANCE_TEMP tmp

1994: From OKC_K_ITEMS KI
1995: , OKC_K_HEADERS_ALL_B KH
1996: , OKC_K_LINES_B KL
1997: , OKC_STATUSES_B ST
1998: , OKS_INSTANCE_TEMP tmp
1999: , OKC_K_LINES_B TL
2000: , OKC_K_ITEMS KIS
2001: , OKS_K_LINES_B OKL
2002: Where tmp.upd = 'Y'

Line 2022: From Oks_subscr_header_b oks, Oks_instance_temp tmp

2018: OR (trunc(tmp.transaction_date) <= trunc(kl.start_date)) );
2019:
2020: Cursor check_subscription_instance Is
2021: Select 'Y'
2022: From Oks_subscr_header_b oks, Oks_instance_temp tmp
2023: Where oks.instance_id = tmp.old_customer_product_id;
2024:
2025: Cursor l_refnum_csr(p_cp_id NUMBER) IS
2026: select instance_number

Line 2070: Delete from Oks_Instance_temp;

2066: l_org_id := MO_GLOBAL.Get_current_org_id;
2067:
2068: MO_Global.set_policy_context('A', null);
2069:
2070: Delete from Oks_Instance_temp;
2071:
2072: FORALL i in P_oks_txn_inst_tbl.FIRST..P_oks_txn_inst_tbl.LAST
2073: INSERT INTO oks_instance_temp
2074: Values P_oks_txn_inst_tbl(i);

Line 2073: INSERT INTO oks_instance_temp

2069:
2070: Delete from Oks_Instance_temp;
2071:
2072: FORALL i in P_oks_txn_inst_tbl.FIRST..P_oks_txn_inst_tbl.LAST
2073: INSERT INTO oks_instance_temp
2074: Values P_oks_txn_inst_tbl(i);
2075:
2076: --If instance is a subscription instance throw an error
2077: Open check_subscription_instance;