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.PO_GEN_DIFF_PKG dependencies on PO_DIFF_CONFIG

Line 386: SELECT DISTINCT entity_name, base_doc_source_name, mod_doc_source_name FROM po_diff_config WHERE document_type = p_document_type and nvl(ignore_source_flag, 'N') = 'N';

382: mod_pk4_value NUMBER,
383: mod_pk5_value NUMBER) IS
384:
385: CURSOR c_entities IS
386: SELECT DISTINCT entity_name, base_doc_source_name, mod_doc_source_name FROM po_diff_config WHERE document_type = p_document_type and nvl(ignore_source_flag, 'N') = 'N';
387:
388: CURSOR c_sources IS
389: SELECT DISTINCT base_doc_source_name, mod_doc_source_name FROM po_diff_config WHERE document_type = p_document_type and entity_name = p_entity_name and nvl(ignore_source_flag, 'N') = 'N';
390:

Line 389: SELECT DISTINCT base_doc_source_name, mod_doc_source_name FROM po_diff_config WHERE document_type = p_document_type and entity_name = p_entity_name and nvl(ignore_source_flag, 'N') = 'N';

385: CURSOR c_entities IS
386: SELECT DISTINCT entity_name, base_doc_source_name, mod_doc_source_name FROM po_diff_config WHERE document_type = p_document_type and nvl(ignore_source_flag, 'N') = 'N';
387:
388: CURSOR c_sources IS
389: SELECT DISTINCT base_doc_source_name, mod_doc_source_name FROM po_diff_config WHERE document_type = p_document_type and entity_name = p_entity_name and nvl(ignore_source_flag, 'N') = 'N';
390:
391: CURSOR c_filter_preds(l_entity_name VARCHAR2, l_base_doc_source_name VARCHAR2, l_mod_doc_source_name VARCHAR2) IS
392: SELECT column_name FROM po_diff_config WHERE document_type = p_document_type and entity_name = l_entity_name and
393: base_doc_source_name = l_base_doc_source_name and mod_doc_source_name = l_mod_doc_source_name

Line 392: SELECT column_name FROM po_diff_config WHERE document_type = p_document_type and entity_name = l_entity_name and

388: CURSOR c_sources IS
389: SELECT DISTINCT base_doc_source_name, mod_doc_source_name FROM po_diff_config WHERE document_type = p_document_type and entity_name = p_entity_name and nvl(ignore_source_flag, 'N') = 'N';
390:
391: CURSOR c_filter_preds(l_entity_name VARCHAR2, l_base_doc_source_name VARCHAR2, l_mod_doc_source_name VARCHAR2) IS
392: SELECT column_name FROM po_diff_config WHERE document_type = p_document_type and entity_name = l_entity_name and
393: base_doc_source_name = l_base_doc_source_name and mod_doc_source_name = l_mod_doc_source_name
394: and nvl(cmp_filter_pred_flag, 'N') = 'Y';
395:
396: