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.OKC_K_ENTITY_LOCKS_GRP dependencies on OKC_K_ARTICLES_B_S

Line 606: FROM okc_k_articles_b SOURCE -- Modification Doc

602: -- Get the list of source clauses from the Modification document
603: CURSOR c_clauses
604: IS
605: SELECT SOURCE.orig_system_reference_id1 old_id, target.ID new_id , klock.LOCK_by_entity_id
606: FROM okc_k_articles_b SOURCE -- Modification Doc
607: ,
608: okc_k_articles_b target -- Base Doc
609: ,
610: okc_k_entity_locks klock -- Locks Table

Line 1241: VALUES (okc_k_articles_b_s.NEXTVAL, l_doc_clause_rec.sav_sae_id,

1237: created_by, creation_date, last_updated_by,
1238: last_update_login, last_update_date,
1239: orig_article_id
1240: )
1241: VALUES (okc_k_articles_b_s.NEXTVAL, l_doc_clause_rec.sav_sae_id,
1242: p_target_document_type, p_target_document_id,
1243: DECODE (p_target_document_type,
1244: 'OKC_BUY', p_target_document_id,
1245: 'OKC_SELL', p_target_document_id,

Line 3396: ,okc_k_articles_b srcMod

3392: IS
3393: SELECT tgtAward.id,srcMod.orig_system_reference_id1
3394: FROM
3395: okc_k_articles_b tgtAward
3396: ,okc_k_articles_b srcMod
3397: WHERE srcMod.document_type= p_update_from_doc_type
3398: AND srcMod.document_id= p_update_from_doc_id
3399: AND tgtAward.document_type= p_update_to_doc_type
3400: AND tgtAward.document_id= p_update_to_doc_id