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_TERMS_UTIL_PVT dependencies on PO_DOCUMENT_TYPES_ALL_B

Line 4773: -- Fix for bug# 5010387, replaced po_document_types_v with po_document_types_all_b and added org_id condition

4769: l_doc_sub_type varchar2(30);
4770: l_layout_template_code varchar2(30) := 'E';
4771:
4772: cursor get_po_lay_templ_csr(l_doc_type VARCHAR2,l_doc_sub_type VARCHAR2) is
4773: -- Fix for bug# 5010387, replaced po_document_types_v with po_document_types_all_b and added org_id condition
4774: SELECT
4775: contract_template_code
4776: FROM po_document_types_all_b
4777: WHERE org_id = p_org_id

Line 4776: FROM po_document_types_all_b

4772: cursor get_po_lay_templ_csr(l_doc_type VARCHAR2,l_doc_sub_type VARCHAR2) is
4773: -- Fix for bug# 5010387, replaced po_document_types_v with po_document_types_all_b and added org_id condition
4774: SELECT
4775: contract_template_code
4776: FROM po_document_types_all_b
4777: WHERE org_id = p_org_id
4778: AND document_type_code = l_doc_type
4779: AND document_subtype= l_doc_sub_type;
4780:

Line 4785: po_document_types_all_b podoctypes,

4781: cursor get_souring_lay_templ_csr is
4782: SELECT
4783: podoctypes.contract_template_code
4784: FROM pon_auction_headers_all pah,
4785: po_document_types_all_b podoctypes,
4786: pon_auc_doctypes pac
4787: WHERE auction_header_id = p_doc_id
4788: AND pah.doctype_id = pac.doctype_id
4789: AND pah.org_id = podoctypes.org_id