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_OPEN_INTERFACE_PVT dependencies on FND_LOOKUP_VALUES

Line 67: object_data := allowed_value_column_object('SECURITY_LEVEL_CODE',allowed_values_table_data); --SELECT MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'PON_SECURITY_LEVEL_CODE' AND LANGUAGE=UserEnv('LANG'))

63: allowed_values_table_data := allowed_values_table('CONTRACT','BLANKET','STANDARD');
64: object_data := allowed_value_column_object('CONTRACT_TYPE',allowed_values_table_data);
65: column_test_table_data(1) := object_data;
66: allowed_values_table_data := allowed_values_table('PUBLIC','PRIVATE','HIERARCHY');
67: object_data := allowed_value_column_object('SECURITY_LEVEL_CODE',allowed_values_table_data); --SELECT MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'PON_SECURITY_LEVEL_CODE' AND LANGUAGE=UserEnv('LANG'))
68: column_test_table_data(2) := object_data;
69: IF(p_contract_type IN ('BLANKET','CONTRACT')) THEN
70: object_data := allowed_value_column_object('GLOBAL_AGREEMENT_FLAG',yn_data);
71: column_test_table_data(3) := object_data;

Line 5733: FROM FND_LOOKUP_VALUES

5729: l_cp_login_id)
5730:
5731: WHEN (isFederal = 1 AND neg_header_record_data.DOCUMENT_FORMAT NOT IN
5732: (SELECT LOOKUP_CODE
5733: FROM FND_LOOKUP_VALUES
5734: WHERE LOOKUP_TYPE = 'PO_CLM_DOC_FORMAT'
5735: AND LANGUAGE = USERENV('LANG')
5736: AND ENABLED_FLAG = 'Y'
5737: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE - 1) AND NVL(END_DATE_ACTIVE, SYSDATE + 1)

Line 5770: FROM FND_LOOKUP_VALUES

5766:
5767: --FEDERAL_PUBLICATION_EXCEPTION
5768: WHEN ( isFederal = 1 AND neg_header_record_data.FEDERAL_PUBLICATION_EXCEPTION NOT IN
5769: ( SELECT LOOKUP_CODE
5770: FROM FND_LOOKUP_VALUES
5771: WHERE LOOKUP_TYPE = 'PON_FEDERAL_PUBLICATION'
5772: AND LANGUAGE = USERENV('LANG')
5773: AND ENABLED_FLAG = 'Y'
5774: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE - 1)

Line 5831: FROM FND_LOOKUP_VALUES

5827: SYSDATE,
5828: l_cp_login_id)
5829:
5830: WHEN ( isFederal = 1 AND neg_header_record_data.SOLICITATION_TYPE NOT IN (SELECT LOOKUP_CODE
5831: FROM FND_LOOKUP_VALUES
5832: WHERE LOOKUP_TYPE = 'PON_SOLICITATION_TYPE'
5833: AND LANGUAGE = USERENV('LANG')
5834: AND ENABLED_FLAG = 'Y'
5835: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE - 1) AND NVL(END_DATE_ACTIVE, SYSDATE + 1)

Line 5892: FROM FND_LOOKUP_VALUES

5888: SYSDATE,
5889: l_cp_login_id)
5890:
5891: WHEN (isFederal = 1 AND neg_header_record_data.STANDARD_FORM NOT IN (SELECT LOOKUP_CODE
5892: FROM FND_LOOKUP_VALUES
5893: WHERE LOOKUP_TYPE = 'PO_SOL_STD_FORM'
5894: AND LANGUAGE = USERENV('LANG')
5895: AND ENABLED_FLAG = 'Y'
5896: AND SYSDATE BETWEEN

Line 6050: AND neg_header_record_data.fob_code NOT IN (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'FOB' AND LANGUAGE=UserEnv('LANG')))

6046: SYSDATE,
6047: l_cp_login_id)
6048:
6049: WHEN(neg_header_record_data.fob_code IS NOT NULL
6050: AND neg_header_record_data.fob_code NOT IN (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'FOB' AND LANGUAGE=UserEnv('LANG')))
6051: THEN INTO PON_INTERFACE_ERRORS
6052: (
6053: INTERFACE_TYPE ,
6054: ERROR_MESSAGE_NAME,

Line 6076: AND neg_header_record_data.freight_terms_code NOT IN (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'FREIGHT TERMS' AND LANGUAGE=UserEnv('LANG')))

6072: l_cp_user_id,
6073: SYSDATE,
6074: l_cp_login_id)
6075: WHEN(neg_header_record_data.freight_terms_code IS NOT NULL
6076: AND neg_header_record_data.freight_terms_code NOT IN (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'FREIGHT TERMS' AND LANGUAGE=UserEnv('LANG')))
6077: THEN INTO PON_INTERFACE_ERRORS
6078: (
6079: INTERFACE_TYPE ,
6080: ERROR_MESSAGE_NAME,