APPS.OKS_IBINT_PUB dependencies on OKS_INSTANCE_K_DTLS_TEMP

Line 2842: delete from oks_instance_k_dtls_temp;

2838:
2839:
2840: -- Delete all the rows in temp table
2841:
2842: delete from oks_instance_k_dtls_temp;
2843:
2844:
2845: --insert all the instances returned returned by IB API
2846:

Line 2847: INSERT INTO oks_instance_k_dtls_temp (parent_id,instance_id)

2843:
2844:
2845: --insert all the instances returned returned by IB API
2846:
2847: INSERT INTO oks_instance_k_dtls_temp (parent_id,instance_id)
2848: values(p_instance_id,p_instance_id);
2849:
2850: FORALL i in 1..l_txn_inst_tbl(1).instance_tbl.count
2851: INSERT INTO oks_instance_k_dtls_temp (parent_id,instance_id)

Line 2851: INSERT INTO oks_instance_k_dtls_temp (parent_id,instance_id)

2847: INSERT INTO oks_instance_k_dtls_temp (parent_id,instance_id)
2848: values(p_instance_id,p_instance_id);
2849:
2850: FORALL i in 1..l_txn_inst_tbl(1).instance_tbl.count
2851: INSERT INTO oks_instance_k_dtls_temp (parent_id,instance_id)
2852: values(p_instance_id,l_txn_inst_tbl(1).instance_tbl(i));
2853:
2854:
2855: END POPULATE_CHILD_INSTANCES;

Line 3191: ,oks_instance_k_dtls_temp temp

3187: From OKC_K_ITEMS KI
3188: ,OKC_K_HEADERS_ALL_B KH
3189: ,OKC_K_LINES_B CL
3190: ,OKC_STATUSES_b ST
3191: ,oks_instance_k_dtls_temp temp
3192: Where KI.Jtot_Object1_code = 'OKX_CUSTPROD'
3193: AND KI.object1_id1 = to_char(temp.instance_id)
3194: And KH.scs_code in ('WARRANTY','SERVICE','SUBSCRIPTION' )
3195: And KI.Cle_id = CL.id

Line 3258: ,oks_instance_k_dtls_temp temp

3254: ,OKC_K_HEADERS_ALL_B KH
3255: ,OKC_K_LINES_B CL
3256: ,OKC_STATUSES_B ST
3257: ,csi_counter_associations CTRASC
3258: ,oks_instance_k_dtls_temp temp
3259: where KI.object1_id1 = to_char(CTRASC.COunter_id)
3260: And KI.jtot_object1_code = 'OKX_COUNTER'
3261: And ctrasc.source_object_id = temp.instance_id
3262: And ctrasc.source_object_code = 'CP'