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

Line 514: po_diff_config c

510: 'M', nvl2(d.mod_value, d.mod_value, 0),
511: nvl(d.mod_value_desc, d.mod_value)) mod_value_desc
512:
513: FROM pon_entity_differences d,
514: po_diff_config c
515:
516: WHERE d.document_type = p_document_type
517: and d.entity_name = p_entity_name
518: and d.mod_doc_pk1_val = p_mod_pk1_value

Line 585: po_diff_config c

581: min(c.disp_data_type) disp_data_type,
582: min(c.sub_entity_name) sub_entity_name
583:
584: FROM po_entity_rollup_gt d,
585: po_diff_config c
586:
587: WHERE d.document_type = p_document_type
588: and d.entity_name = p_entity_name
589: and d.mod_doc_pk1_val = mod_pk1_value

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

707: mod_pk4_value NUMBER,
708: mod_pk5_value NUMBER ) IS
709:
710: CURSOR c_entities IS
711: SELECT DISTINCT entity_name, base_doc_source_name, mod_doc_source_name FROM po_diff_config WHERE document_type = p_document_type and nvl(rollup_eligibility_flag, 'N') = 'Y' and nvl(ignore_source_flag, 'N') = 'N';
712:
713: CURSOR c_sources IS
714: 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(rollup_eligibility_flag, 'N') = 'Y' and nvl(ignore_source_flag, 'N') = 'N';
715:

Line 714: 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(rollup_eligibility_flag, 'N') = 'Y' and nvl(ignore_source_flag, 'N') = 'N';

710: CURSOR c_entities IS
711: SELECT DISTINCT entity_name, base_doc_source_name, mod_doc_source_name FROM po_diff_config WHERE document_type = p_document_type and nvl(rollup_eligibility_flag, 'N') = 'Y' and nvl(ignore_source_flag, 'N') = 'N';
712:
713: CURSOR c_sources IS
714: 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(rollup_eligibility_flag, 'N') = 'Y' and nvl(ignore_source_flag, 'N') = 'N';
715:
716: BEGIN
717:
718: IF p_entity_name = 'ALL' THEN

Line 866: l_rfc_stmt := 'SELECT d.column_name, d.orig_value, d.mod_value from pon_entity_differences d, po_diff_config c

862: ''' and d.entity_name = ''' || p_entity_name ||
863: ''' and d.mod_doc_source_name = ''' || p_mod_doc_source || '''';
864:
865: --sql stmt to get the rollup changes
866: l_rfc_stmt := 'SELECT d.column_name, d.orig_value, d.mod_value from pon_entity_differences d, po_diff_config c
867: where ' || l_where_stmt ||
868: ' and c.column_name = d.column_name
869: and nvl(c.rollup_eligibility_flag, ''N'') = ''Y''
870: and c.document_type = '''|| p_document_type ||'''