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 4724: -- Fix for bug# 5010387, replaced po_document_types_v with po_document_types_all_b and added org_id condition

4720: l_doc_sub_type varchar2(30);
4721: l_layout_template_code varchar2(30) := 'E';
4722:
4723: cursor get_po_lay_templ_csr(l_doc_type VARCHAR2,l_doc_sub_type VARCHAR2) is
4724: -- Fix for bug# 5010387, replaced po_document_types_v with po_document_types_all_b and added org_id condition
4725: SELECT
4726: contract_template_code
4727: FROM po_document_types_all_b
4728: WHERE org_id = p_org_id

Line 4727: FROM po_document_types_all_b

4723: cursor get_po_lay_templ_csr(l_doc_type VARCHAR2,l_doc_sub_type VARCHAR2) is
4724: -- Fix for bug# 5010387, replaced po_document_types_v with po_document_types_all_b and added org_id condition
4725: SELECT
4726: contract_template_code
4727: FROM po_document_types_all_b
4728: WHERE org_id = p_org_id
4729: AND document_type_code = l_doc_type
4730: AND document_subtype= l_doc_sub_type;
4731:

Line 4736: po_document_types_all_b podoctypes,

4732: cursor get_souring_lay_templ_csr is
4733: SELECT
4734: podoctypes.contract_template_code
4735: FROM pon_auction_headers_all pah,
4736: po_document_types_all_b podoctypes,
4737: pon_auc_doctypes pac
4738: WHERE auction_header_id = p_doc_id
4739: AND pah.doctype_id = pac.doctype_id
4740: AND pah.org_id = podoctypes.org_id