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.

[Home] [Help]

APPS.PON_FORMS_JRAD_PVT dependencies on PON_FIELDS_TL

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 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 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 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 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 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 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 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 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: