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_SGD_PKG dependencies on PO_DIFF_CONFIG

Line 673: po_diff_config c

669:
670: FROM po_entity_rollup_gt WHERE '|| l_where_stmt || '
671: ) d,
672:
673: po_diff_config c
674:
675: WHERE c.document_type = ''' || p_document_type
676: || ''' and c.entity_name = '''|| p_entity_name
677: || ''' and c.mod_doc_source_name = d.mod_doc_source_name

Line 829: po_diff_config c

825: min(c.disp_data_type),
826: min(c.sub_entity_name)
827:
828: FROM po_entity_rollup_gt d,
829: po_diff_config c
830:
831: WHERE ' || l_where_stmt
832: || ' and c.document_type = ''' || p_document_type
833: || ''' and c.entity_name = '''|| p_entity_name

Line 1082: po_diff_config c

1078: min(c.disp_data_type),
1079: min(c.sub_entity_name)
1080:
1081: FROM po_entity_rollup_gt d,
1082: po_diff_config c
1083:
1084: WHERE ' || l_where_stmt
1085: || ' and c.document_type = ''' || p_document_type
1086: || ''' and c.entity_name = '''|| p_entity_name

Line 1368: po_diff_config c

1364: min(c.disp_data_type),
1365: min(c.sub_entity_name)
1366:
1367: FROM po_entity_rollup_gt d,
1368: po_diff_config c
1369:
1370: WHERE ' || l_where_stmt
1371: || ' and c.document_type = ''' || p_document_type
1372: || ''' and c.entity_name = '''|| p_entity_name

Line 1539: 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';

1535: mod_pk4_value NUMBER,
1536: mod_pk5_value NUMBER) IS
1537:
1538: CURSOR c_entities IS
1539: 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';
1540:
1541: CURSOR c_sources IS
1542: 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';
1543:

Line 1542: 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';

1538: CURSOR c_entities IS
1539: 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';
1540:
1541: CURSOR c_sources IS
1542: 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';
1543:
1544: BEGIN
1545:
1546: IF p_entity_name = 'ALL' THEN

Line 1694: l_rfc_stmt := 'SELECT d.column_name, d.orig_value, d.mod_value from po_entity_differences d, po_diff_config c

1690: ''' and d.entity_name = ''' || p_entity_name ||
1691: ''' and d.mod_doc_source_name = ''' || p_mod_doc_source || '''';
1692:
1693: --sql stmt to get the rollup changes
1694: l_rfc_stmt := 'SELECT d.column_name, d.orig_value, d.mod_value from po_entity_differences d, po_diff_config c
1695: where ' || l_where_stmt ||
1696: ' and c.column_name = d.column_name
1697: and nvl(c.rollup_eligibility_flag, ''N'') = ''Y''
1698: and c.document_type = '''|| p_document_type ||'''