APPS.OKS_IBINT_PUB dependencies on OKS_INSTANCE_K_DTLS_TEMP

Line 2862: delete from oks_instance_k_dtls_temp;

2858:
2859:
2860: -- Delete all the rows in temp table
2861:
2862: delete from oks_instance_k_dtls_temp;
2863:
2864:
2865: --insert all the instances returned returned by IB API
2866:

Line 2867: INSERT INTO oks_instance_k_dtls_temp (parent_id,instance_id)

2863:
2864:
2865: --insert all the instances returned returned by IB API
2866:
2867: INSERT INTO oks_instance_k_dtls_temp (parent_id,instance_id)
2868: values(p_instance_id,p_instance_id);
2869:
2870: /* FORALL i in 1..l_txn_inst_tbl(1).instance_tbl.count */
2871: /* cgopinee bugfix for bug 9289886*/

Line 2873: INSERT INTO oks_instance_k_dtls_temp (parent_id,instance_id)

2869:
2870: /* FORALL i in 1..l_txn_inst_tbl(1).instance_tbl.count */
2871: /* cgopinee bugfix for bug 9289886*/
2872: FORALL i IN indices OF l_txn_inst_tbl(1).instance_tbl
2873: INSERT INTO oks_instance_k_dtls_temp (parent_id,instance_id)
2874: values(p_instance_id,l_txn_inst_tbl(1).instance_tbl(i));
2875:
2876: END POPULATE_CHILD_INSTANCES;
2877:

Line 3223: ,oks_instance_k_dtls_temp temp

3219: From OKC_K_ITEMS KI
3220: ,OKC_K_HEADERS_ALL_B KH
3221: ,OKC_K_LINES_B CL
3222: ,OKC_STATUSES_b ST
3223: ,oks_instance_k_dtls_temp temp
3224: Where KI.Jtot_Object1_code = 'OKX_CUSTPROD'
3225: AND KI.object1_id1 = to_char(temp.instance_id)
3226: And KH.scs_code in ('WARRANTY','SERVICE','SUBSCRIPTION' )
3227: And KI.Cle_id = CL.id

Line 3290: ,oks_instance_k_dtls_temp temp

3286: ,OKC_K_HEADERS_ALL_B KH
3287: ,OKC_K_LINES_B CL
3288: ,OKC_STATUSES_B ST
3289: ,csi_counter_associations CTRASC
3290: ,oks_instance_k_dtls_temp temp
3291: where KI.object1_id1 = to_char(CTRASC.COunter_id)
3292: And KI.jtot_object1_code = 'OKX_COUNTER'
3293: And ctrasc.source_object_id = temp.instance_id
3294: And ctrasc.source_object_code = 'CP'