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_FORMS_JRAD_PVT dependencies on PON_FIELDS

Line 71: from pon_fields,

67:
68: BEGIN
69: select decode(fnd_flex_value_sets.longlist_flag, 'X', 'N', 'Y') isLov
70: into v_ret_value
71: from pon_fields,
72: fnd_flex_value_sets
73: where pon_fields.value_set_name = fnd_flex_value_sets.flex_value_set_name
74: and pon_fields.value_set_name is not null
75: and pon_fields.field_code = p_field_code;

Line 73: where pon_fields.value_set_name = fnd_flex_value_sets.flex_value_set_name

69: select decode(fnd_flex_value_sets.longlist_flag, 'X', 'N', 'Y') isLov
70: into v_ret_value
71: from pon_fields,
72: fnd_flex_value_sets
73: where pon_fields.value_set_name = fnd_flex_value_sets.flex_value_set_name
74: and pon_fields.value_set_name is not null
75: and pon_fields.field_code = p_field_code;
76:
77: EXCEPTION

Line 74: and pon_fields.value_set_name is not null

70: into v_ret_value
71: from pon_fields,
72: fnd_flex_value_sets
73: where pon_fields.value_set_name = fnd_flex_value_sets.flex_value_set_name
74: and pon_fields.value_set_name is not null
75: and pon_fields.field_code = p_field_code;
76:
77: EXCEPTION
78: WHEN OTHERS THEN

Line 75: and pon_fields.field_code = p_field_code;

71: from pon_fields,
72: fnd_flex_value_sets
73: where pon_fields.value_set_name = fnd_flex_value_sets.flex_value_set_name
74: and pon_fields.value_set_name is not null
75: and pon_fields.field_code = p_field_code;
76:
77: EXCEPTION
78: WHEN OTHERS THEN
79: v_ret_value := 'N';

Line 824: pon_fields.DATATYPE ,

820: pon_form_section_compiled.MAPPING_FIELD_VALUE_COLUMN,
821: pon_form_section_compiled.REQUIRED,
822: NVL (pon_form_section_compiled.LEVEL1_SECTION_ID, -1) LEVEL1_SECTION_ID,
823: pon_forms_sections.FORM_CODE SECTION_CODE,
824: pon_fields.DATATYPE ,
825: pon_fields.VALUE_SET_NAME,
826: pon_fields.SYSTEM_FLAG,
827: pon_fields_tl.FIELD_NAME,
828: pon_fields_tl.DESCRIPTION FIELD_DESCRIPTION,

Line 825: pon_fields.VALUE_SET_NAME,

821: pon_form_section_compiled.REQUIRED,
822: NVL (pon_form_section_compiled.LEVEL1_SECTION_ID, -1) LEVEL1_SECTION_ID,
823: pon_forms_sections.FORM_CODE SECTION_CODE,
824: pon_fields.DATATYPE ,
825: pon_fields.VALUE_SET_NAME,
826: pon_fields.SYSTEM_FLAG,
827: pon_fields_tl.FIELD_NAME,
828: pon_fields_tl.DESCRIPTION FIELD_DESCRIPTION,
829: pon_form_section_compiled.INTERNAL_SEQUENCE_NUMBER,

Line 826: pon_fields.SYSTEM_FLAG,

822: NVL (pon_form_section_compiled.LEVEL1_SECTION_ID, -1) LEVEL1_SECTION_ID,
823: pon_forms_sections.FORM_CODE SECTION_CODE,
824: pon_fields.DATATYPE ,
825: pon_fields.VALUE_SET_NAME,
826: pon_fields.SYSTEM_FLAG,
827: pon_fields_tl.FIELD_NAME,
828: pon_fields_tl.DESCRIPTION FIELD_DESCRIPTION,
829: pon_form_section_compiled.INTERNAL_SEQUENCE_NUMBER,
830: NVL(pon_form_section_compiled.LEVEL2_SECTION_ID, -1) LEVEL2_SECTION_ID,

Line 827: pon_fields_tl.FIELD_NAME,

823: pon_forms_sections.FORM_CODE SECTION_CODE,
824: pon_fields.DATATYPE ,
825: pon_fields.VALUE_SET_NAME,
826: pon_fields.SYSTEM_FLAG,
827: pon_fields_tl.FIELD_NAME,
828: pon_fields_tl.DESCRIPTION FIELD_DESCRIPTION,
829: pon_form_section_compiled.INTERNAL_SEQUENCE_NUMBER,
830: NVL(pon_form_section_compiled.LEVEL2_SECTION_ID, -1) LEVEL2_SECTION_ID,
831: NVL(pon_form_section_compiled.REPEATING_SECTION_ID, -1) SECTION_ID

Line 828: pon_fields_tl.DESCRIPTION FIELD_DESCRIPTION,

824: pon_fields.DATATYPE ,
825: pon_fields.VALUE_SET_NAME,
826: pon_fields.SYSTEM_FLAG,
827: pon_fields_tl.FIELD_NAME,
828: pon_fields_tl.DESCRIPTION FIELD_DESCRIPTION,
829: pon_form_section_compiled.INTERNAL_SEQUENCE_NUMBER,
830: NVL(pon_form_section_compiled.LEVEL2_SECTION_ID, -1) LEVEL2_SECTION_ID,
831: NVL(pon_form_section_compiled.REPEATING_SECTION_ID, -1) SECTION_ID
832: FROM PON_FORM_SECTION_COMPILED,

Line 833: PON_FIELDS,

829: pon_form_section_compiled.INTERNAL_SEQUENCE_NUMBER,
830: NVL(pon_form_section_compiled.LEVEL2_SECTION_ID, -1) LEVEL2_SECTION_ID,
831: NVL(pon_form_section_compiled.REPEATING_SECTION_ID, -1) SECTION_ID
832: FROM PON_FORM_SECTION_COMPILED,
833: PON_FIELDS,
834: PON_FIELDS_TL,
835: PON_FORMS_SECTIONS
836: WHERE pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE(+)
837: AND pon_form_section_compiled.FIELD_CODE = pon_fields_tl.FIELD_CODE(+)

Line 834: PON_FIELDS_TL,

830: NVL(pon_form_section_compiled.LEVEL2_SECTION_ID, -1) LEVEL2_SECTION_ID,
831: NVL(pon_form_section_compiled.REPEATING_SECTION_ID, -1) SECTION_ID
832: FROM PON_FORM_SECTION_COMPILED,
833: PON_FIELDS,
834: PON_FIELDS_TL,
835: PON_FORMS_SECTIONS
836: WHERE pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE(+)
837: AND pon_form_section_compiled.FIELD_CODE = pon_fields_tl.FIELD_CODE(+)
838: AND pon_forms_sections.FORM_ID = P_FORM_ID

Line 836: WHERE pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE(+)

832: FROM PON_FORM_SECTION_COMPILED,
833: PON_FIELDS,
834: PON_FIELDS_TL,
835: PON_FORMS_SECTIONS
836: WHERE pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE(+)
837: AND pon_form_section_compiled.FIELD_CODE = pon_fields_tl.FIELD_CODE(+)
838: AND pon_forms_sections.FORM_ID = P_FORM_ID
839: AND pon_form_section_compiled.FORM_ID = P_FORM_ID
840: AND pon_form_section_compiled.TYPE IN ('FORM_FIELD', 'REPEAT_SECTION')

Line 837: AND pon_form_section_compiled.FIELD_CODE = pon_fields_tl.FIELD_CODE(+)

833: PON_FIELDS,
834: PON_FIELDS_TL,
835: PON_FORMS_SECTIONS
836: WHERE pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE(+)
837: AND pon_form_section_compiled.FIELD_CODE = pon_fields_tl.FIELD_CODE(+)
838: AND pon_forms_sections.FORM_ID = P_FORM_ID
839: AND pon_form_section_compiled.FORM_ID = P_FORM_ID
840: AND pon_form_section_compiled.TYPE IN ('FORM_FIELD', 'REPEAT_SECTION')
841: AND pon_fields_tl.LANGUAGE(+) = g_base_language

Line 841: AND pon_fields_tl.LANGUAGE(+) = g_base_language

837: AND pon_form_section_compiled.FIELD_CODE = pon_fields_tl.FIELD_CODE(+)
838: AND pon_forms_sections.FORM_ID = P_FORM_ID
839: AND pon_form_section_compiled.FORM_ID = P_FORM_ID
840: AND pon_form_section_compiled.TYPE IN ('FORM_FIELD', 'REPEAT_SECTION')
841: AND pon_fields_tl.LANGUAGE(+) = g_base_language
842: ORDER BY
843: INTERNAL_SEQUENCE_NUMBER;
844:
845: v_section_field_element JDR_DOCBUILDER.ELEMENT;

Line 1462: select pon_fields.field_code,

1458: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ABSTRACT_TABLE';
1459:
1460: CURSOR V_ABSTRACT_FIELDS_CURSOR IS
1461:
1462: select pon_fields.field_code,
1463: pon_form_section_compiled.mapping_field_value_column,
1464: pon_fields.datatype,
1465: pon_fields.value_set_name,
1466: pon_fields.system_flag,

Line 1464: pon_fields.datatype,

1460: CURSOR V_ABSTRACT_FIELDS_CURSOR IS
1461:
1462: select pon_fields.field_code,
1463: pon_form_section_compiled.mapping_field_value_column,
1464: pon_fields.datatype,
1465: pon_fields.value_set_name,
1466: pon_fields.system_flag,
1467: pon_fields.system_field_lov_flag,
1468: pon_fields_tl.field_name,

Line 1465: pon_fields.value_set_name,

1461:
1462: select pon_fields.field_code,
1463: pon_form_section_compiled.mapping_field_value_column,
1464: pon_fields.datatype,
1465: pon_fields.value_set_name,
1466: pon_fields.system_flag,
1467: pon_fields.system_field_lov_flag,
1468: pon_fields_tl.field_name,
1469: pon_fields_tl.description field_description,

Line 1466: pon_fields.system_flag,

1462: select pon_fields.field_code,
1463: pon_form_section_compiled.mapping_field_value_column,
1464: pon_fields.datatype,
1465: pon_fields.value_set_name,
1466: pon_fields.system_flag,
1467: pon_fields.system_field_lov_flag,
1468: pon_fields_tl.field_name,
1469: pon_fields_tl.description field_description,
1470: pon_forms_sections.form_id,

Line 1467: pon_fields.system_field_lov_flag,

1463: pon_form_section_compiled.mapping_field_value_column,
1464: pon_fields.datatype,
1465: pon_fields.value_set_name,
1466: pon_fields.system_flag,
1467: pon_fields.system_field_lov_flag,
1468: pon_fields_tl.field_name,
1469: pon_fields_tl.description field_description,
1470: pon_forms_sections.form_id,
1471: pon_forms_sections.form_code,

Line 1468: pon_fields_tl.field_name,

1464: pon_fields.datatype,
1465: pon_fields.value_set_name,
1466: pon_fields.system_flag,
1467: pon_fields.system_field_lov_flag,
1468: pon_fields_tl.field_name,
1469: pon_fields_tl.description field_description,
1470: pon_forms_sections.form_id,
1471: pon_forms_sections.form_code,
1472: pon_forms_sections_tl.form_name,

Line 1469: pon_fields_tl.description field_description,

1465: pon_fields.value_set_name,
1466: pon_fields.system_flag,
1467: pon_fields.system_field_lov_flag,
1468: pon_fields_tl.field_name,
1469: pon_fields_tl.description field_description,
1470: pon_forms_sections.form_id,
1471: pon_forms_sections.form_code,
1472: pon_forms_sections_tl.form_name,
1473: pon_forms_sections_tl.form_description,

Line 1476: from pon_fields,

1472: pon_forms_sections_tl.form_name,
1473: pon_forms_sections_tl.form_description,
1474: pon_form_section_compiled.display_on_main_page,
1475: pon_form_section_compiled.internal_sequence_number
1476: from pon_fields,
1477: pon_fields_tl,
1478: pon_forms_sections,
1479: pon_forms_sections_tl,
1480: pon_form_section_compiled

Line 1477: pon_fields_tl,

1473: pon_forms_sections_tl.form_description,
1474: pon_form_section_compiled.display_on_main_page,
1475: pon_form_section_compiled.internal_sequence_number
1476: from pon_fields,
1477: pon_fields_tl,
1478: pon_forms_sections,
1479: pon_forms_sections_tl,
1480: pon_form_section_compiled
1481: where

Line 1488: and pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE

1484: and pon_forms_sections.FORM_ID = pon_form_section_compiled.FORM_ID
1485: and pon_forms_sections.FORM_ID = pon_forms_sections_tl.FORM_ID
1486: and pon_form_section_compiled.TYPE = 'FORM_FIELD'
1487: and pon_form_section_compiled.FIELD_CODE is not null
1488: and pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE
1489: and pon_fields.FIELD_CODE = pon_fields_tl.FIELD_CODE
1490: and pon_fields_tl.LANGUAGE = g_base_language
1491: and pon_forms_sections_tl.LANGUAGE = g_base_language
1492: and nvl(pon_form_section_compiled.display_on_main_page, 'N') = 'Y'

Line 1489: and pon_fields.FIELD_CODE = pon_fields_tl.FIELD_CODE

1485: and pon_forms_sections.FORM_ID = pon_forms_sections_tl.FORM_ID
1486: and pon_form_section_compiled.TYPE = 'FORM_FIELD'
1487: and pon_form_section_compiled.FIELD_CODE is not null
1488: and pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE
1489: and pon_fields.FIELD_CODE = pon_fields_tl.FIELD_CODE
1490: and pon_fields_tl.LANGUAGE = g_base_language
1491: and pon_forms_sections_tl.LANGUAGE = g_base_language
1492: and nvl(pon_form_section_compiled.display_on_main_page, 'N') = 'Y'
1493: order by

Line 1490: and pon_fields_tl.LANGUAGE = g_base_language

1486: and pon_form_section_compiled.TYPE = 'FORM_FIELD'
1487: and pon_form_section_compiled.FIELD_CODE is not null
1488: and pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE
1489: and pon_fields.FIELD_CODE = pon_fields_tl.FIELD_CODE
1490: and pon_fields_tl.LANGUAGE = g_base_language
1491: and pon_forms_sections_tl.LANGUAGE = g_base_language
1492: and nvl(pon_form_section_compiled.display_on_main_page, 'N') = 'Y'
1493: order by
1494: internal_sequence_number;

Line 1676: pon_fields.DATATYPE,

1672: pon_form_section_compiled.MAPPING_FIELD_VALUE_COLUMN,
1673: pon_form_section_compiled.REQUIRED,
1674: NVL (pon_form_section_compiled.LEVEL1_SECTION_ID, -1) SECTION_ID,
1675: pon_forms_sections.FORM_CODE SECTION_CODE,
1676: pon_fields.DATATYPE,
1677: pon_fields.SYSTEM_FLAG,
1678: pon_fields.VALUE_SET_NAME,
1679: pon_fields_tl.FIELD_NAME,
1680: pon_fields_tl.DESCRIPTION FIELD_DESCRIPTION,

Line 1677: pon_fields.SYSTEM_FLAG,

1673: pon_form_section_compiled.REQUIRED,
1674: NVL (pon_form_section_compiled.LEVEL1_SECTION_ID, -1) SECTION_ID,
1675: pon_forms_sections.FORM_CODE SECTION_CODE,
1676: pon_fields.DATATYPE,
1677: pon_fields.SYSTEM_FLAG,
1678: pon_fields.VALUE_SET_NAME,
1679: pon_fields_tl.FIELD_NAME,
1680: pon_fields_tl.DESCRIPTION FIELD_DESCRIPTION,
1681: pon_form_section_compiled.INTERNAL_SEQUENCE_NUMBER,

Line 1678: pon_fields.VALUE_SET_NAME,

1674: NVL (pon_form_section_compiled.LEVEL1_SECTION_ID, -1) SECTION_ID,
1675: pon_forms_sections.FORM_CODE SECTION_CODE,
1676: pon_fields.DATATYPE,
1677: pon_fields.SYSTEM_FLAG,
1678: pon_fields.VALUE_SET_NAME,
1679: pon_fields_tl.FIELD_NAME,
1680: pon_fields_tl.DESCRIPTION FIELD_DESCRIPTION,
1681: pon_form_section_compiled.INTERNAL_SEQUENCE_NUMBER,
1682: NVL(pon_form_section_compiled.LEVEL2_SECTION_ID, -1) LEVEL2_SECTION_ID,

Line 1679: pon_fields_tl.FIELD_NAME,

1675: pon_forms_sections.FORM_CODE SECTION_CODE,
1676: pon_fields.DATATYPE,
1677: pon_fields.SYSTEM_FLAG,
1678: pon_fields.VALUE_SET_NAME,
1679: pon_fields_tl.FIELD_NAME,
1680: pon_fields_tl.DESCRIPTION FIELD_DESCRIPTION,
1681: pon_form_section_compiled.INTERNAL_SEQUENCE_NUMBER,
1682: NVL(pon_form_section_compiled.LEVEL2_SECTION_ID, -1) LEVEL2_SECTION_ID,
1683: NVL(pon_form_section_compiled.REPEATING_SECTION_ID, -1) REPEATING_SECTION_ID,

Line 1680: pon_fields_tl.DESCRIPTION FIELD_DESCRIPTION,

1676: pon_fields.DATATYPE,
1677: pon_fields.SYSTEM_FLAG,
1678: pon_fields.VALUE_SET_NAME,
1679: pon_fields_tl.FIELD_NAME,
1680: pon_fields_tl.DESCRIPTION FIELD_DESCRIPTION,
1681: pon_form_section_compiled.INTERNAL_SEQUENCE_NUMBER,
1682: NVL(pon_form_section_compiled.LEVEL2_SECTION_ID, -1) LEVEL2_SECTION_ID,
1683: NVL(pon_form_section_compiled.REPEATING_SECTION_ID, -1) REPEATING_SECTION_ID,
1684: pon_form_section_compiled.EDITABLE

Line 1686: PON_FIELDS,

1682: NVL(pon_form_section_compiled.LEVEL2_SECTION_ID, -1) LEVEL2_SECTION_ID,
1683: NVL(pon_form_section_compiled.REPEATING_SECTION_ID, -1) REPEATING_SECTION_ID,
1684: pon_form_section_compiled.EDITABLE
1685: FROM PON_FORM_SECTION_COMPILED,
1686: PON_FIELDS,
1687: PON_FIELDS_TL,
1688: PON_FORMS_SECTIONS
1689: WHERE pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE(+)
1690: AND pon_form_section_compiled.FIELD_CODE = pon_fields_tl.FIELD_CODE(+)

Line 1687: PON_FIELDS_TL,

1683: NVL(pon_form_section_compiled.REPEATING_SECTION_ID, -1) REPEATING_SECTION_ID,
1684: pon_form_section_compiled.EDITABLE
1685: FROM PON_FORM_SECTION_COMPILED,
1686: PON_FIELDS,
1687: PON_FIELDS_TL,
1688: PON_FORMS_SECTIONS
1689: WHERE pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE(+)
1690: AND pon_form_section_compiled.FIELD_CODE = pon_fields_tl.FIELD_CODE(+)
1691: AND pon_forms_sections.FORM_ID = pon_form_section_compiled.FORM_ID

Line 1689: WHERE pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE(+)

1685: FROM PON_FORM_SECTION_COMPILED,
1686: PON_FIELDS,
1687: PON_FIELDS_TL,
1688: PON_FORMS_SECTIONS
1689: WHERE pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE(+)
1690: AND pon_form_section_compiled.FIELD_CODE = pon_fields_tl.FIELD_CODE(+)
1691: AND pon_forms_sections.FORM_ID = pon_form_section_compiled.FORM_ID
1692: AND pon_form_section_compiled.FORM_ID = P_FORM_ID
1693: AND NVL(pon_form_section_compiled.ENABLED, 'Y') = 'Y'

Line 1690: AND pon_form_section_compiled.FIELD_CODE = pon_fields_tl.FIELD_CODE(+)

1686: PON_FIELDS,
1687: PON_FIELDS_TL,
1688: PON_FORMS_SECTIONS
1689: WHERE pon_form_section_compiled.FIELD_CODE = pon_fields.FIELD_CODE(+)
1690: AND pon_form_section_compiled.FIELD_CODE = pon_fields_tl.FIELD_CODE(+)
1691: AND pon_forms_sections.FORM_ID = pon_form_section_compiled.FORM_ID
1692: AND pon_form_section_compiled.FORM_ID = P_FORM_ID
1693: AND NVL(pon_form_section_compiled.ENABLED, 'Y') = 'Y'
1694: AND pon_fields_tl.LANGUAGE(+) = g_base_language

Line 1694: AND pon_fields_tl.LANGUAGE(+) = g_base_language

1690: AND pon_form_section_compiled.FIELD_CODE = pon_fields_tl.FIELD_CODE(+)
1691: AND pon_forms_sections.FORM_ID = pon_form_section_compiled.FORM_ID
1692: AND pon_form_section_compiled.FORM_ID = P_FORM_ID
1693: AND NVL(pon_form_section_compiled.ENABLED, 'Y') = 'Y'
1694: AND pon_fields_tl.LANGUAGE(+) = g_base_language
1695: ORDER BY
1696: INTERNAL_SEQUENCE_NUMBER;
1697:
1698: