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_REP_CLOSEOUT_PVT dependencies on OKC_REP_CONTRACT_USAGES

Line 240: FROM okc_rep_contract_usages

236: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
237:
238: CURSOR c_get_doc_details IS
239: SELECT business_document_type, business_document_id
240: FROM okc_rep_contract_usages
241: WHERE contract_type = p_contract_type
242: AND contract_id = p_contract_id
243: AND contract_version = p_contract_version_num;
244:

Line 424: FROM okc_rep_contract_usages orcu, okc_rep_contracts_all orca

420:
421: CURSOR c_get_doc_details IS
422: SELECT orcu.business_document_type, orcu.business_document_id,
423: orca.contract_effective_date
424: FROM okc_rep_contract_usages orcu, okc_rep_contracts_all orca
425: WHERE orca.contract_id = p_contract_id
426: AND orca.contract_type = orcu.contract_type
427: AND orcu.contract_version = orca.contract_version_num
428: AND orca.contract_id = orcu.contract_id;

Line 602: FROM okc_rep_contract_usages orcu, okc_rep_contracts_all orca

598:
599: CURSOR c_get_doc_details IS
600: SELECT orcu.business_document_type, orcu.business_document_id,
601: orca.contract_effective_date
602: FROM okc_rep_contract_usages orcu, okc_rep_contracts_all orca
603: WHERE orca.contract_id = p_contract_id
604: AND orca.contract_type = orcu.contract_type
605: AND orcu.contract_version = orca.contract_version_num
606: AND orca.contract_id = orcu.contract_id;

Line 858: SELECT contract_type, contract_id FROM okc_rep_contract_usages

854: WHERE contract_id = p_contract_id
855: AND contract_type = p_contract_type;
856:
857: CURSOR c_get_contract_id_csr IS
858: SELECT contract_type, contract_id FROM okc_rep_contract_usages
859: WHERE business_document_id = p_document_rec.business_document_id
860: AND business_document_type = p_document_rec.business_document_type;
861:
862: contract_rec contract_csr%ROWTYPE;

Line 1522: The relation of parent document which is obtained in p_document_rec is stored in the okc_rep_contract_usages table

1518: /*
1519: Creates a new version of the contract contract in draft status.
1520: Updates to the contract should be done from UI.
1521:
1522: The relation of parent document which is obtained in p_document_rec is stored in the okc_rep_contract_usages table
1523: */
1524:
1525: Procedure create_new_contract_version(p_api_version IN NUMBER,
1526: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

Line 1816: FROM okc_rep_contract_usages orcu, okc_rep_contracts_all orc

1812:
1813: IF (all_dels_completed = 'Y') THEN
1814:
1815: SELECT orcu.business_document_id INTO l_po_header_id
1816: FROM okc_rep_contract_usages orcu, okc_rep_contracts_all orc
1817: WHERE orcu.contract_id = l_del_rec.business_document_id
1818: AND orcu.contract_type = l_del_rec.business_document_type
1819: AND orc.contract_id = orcu.contract_id
1820: AND orc.contract_type = orcu.contract_type

Line 1879: FROM okc_rep_contract_usages orcu, okc_rep_contracts_all orca

1875:
1876: CURSOR c_get_doc_details IS
1877: SELECT orcu.contract_type, orcu.contract_id,
1878: orca.contract_effective_date
1879: FROM okc_rep_contract_usages orcu, okc_rep_contracts_all orca
1880: WHERE orcu.business_document_id = p_document_rec.business_document_id
1881: and orcu.business_document_type = p_document_rec.business_document_type
1882: AND orca.contract_type = orcu.contract_type
1883: AND orcu.contract_version = orca.contract_version_num

Line 2126: FROM okc_rep_contract_usages orcu, okc_rep_contracts_all orca

2122: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
2123:
2124: CURSOR c_get_src_contract IS
2125: SELECT orcu.contract_id
2126: FROM okc_rep_contract_usages orcu, okc_rep_contracts_all orca
2127: WHERE orcu.business_document_id = p_src_document_rec.business_document_id
2128: and orcu.business_document_type = p_src_document_rec.business_document_type
2129: AND orca.contract_type = orcu.contract_type
2130: AND orcu.contract_version = orca.contract_version_num

Line 2135: FROM okc_rep_contract_usages orcu, okc_rep_contracts_all orca

2131: AND orca.contract_id = orcu.contract_id;
2132:
2133: CURSOR c_get_tgt_contract IS
2134: SELECT orcu.contract_id
2135: FROM okc_rep_contract_usages orcu, okc_rep_contracts_all orca
2136: WHERE orcu.business_document_id = p_tgt_document_rec.business_document_id
2137: and orcu.business_document_type = p_tgt_document_rec.business_document_type
2138: AND orca.contract_type = orcu.contract_type
2139: AND orcu.contract_version = orca.contract_version_num

Line 2380: FROM okc_rep_contract_usages orcu, okc_deliverables del

2376: IS
2377:
2378: CURSOR c_get_tasks_exists_csr IS
2379: SELECT Count(deliverable_id)
2380: FROM okc_rep_contract_usages orcu, okc_deliverables del
2381: WHERE orcu.business_document_type = p_document_rec.business_document_type
2382: AND orcu.business_document_id = p_document_rec.business_document_id
2383: AND del.business_document_type = orcu.contract_type
2384: AND del.business_document_id = orcu.contract_id