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.XLA_LINE_TYPES_PKG dependencies on XLA_LINE_DEFN_JLT_ASSGNS

Line 438: FROM xla_line_defn_jlt_assgns

434:
435: CURSOR c_assignment_exist
436: IS
437: SELECT event_type_code, line_definition_owner_code, line_definition_code
438: FROM xla_line_defn_jlt_assgns
439: WHERE application_id = p_application_id
440: AND amb_context_code = p_amb_context_code
441: AND event_class_code = p_event_class_code
442: AND accounting_line_type_code = p_accounting_line_type_code

Line 450: FROM xla_line_defn_jlt_assgns

446:
447: CURSOR c_active_assignment_exist
448: IS
449: SELECT event_type_code, line_definition_owner_code, line_definition_code
450: FROM xla_line_defn_jlt_assgns
451: WHERE application_id = p_application_id
452: AND amb_context_code = p_amb_context_code
453: AND event_class_code = p_event_class_code
454: AND accounting_line_type_code = p_accounting_line_type_code

Line 481: xla_line_defn_jlt_assgns jlt

477: mpa_jlt.line_definition_code,
478: mpa_jlt.accounting_line_type_code,
479: mpa_jlt.accounting_line_code
480: FROM xla_mpa_jlt_assgns mpa_jlt,
481: xla_line_defn_jlt_assgns jlt
482: WHERE mpa_jlt.application_id = p_application_id
483: AND mpa_jlt.amb_context_code = p_amb_context_code
484: AND mpa_jlt.event_class_code = p_event_class_code
485: AND mpa_jlt.mpa_accounting_line_type_code = p_accounting_line_type_code

Line 757: FROM xla_line_defn_jlt_assgns s

753:
754: CURSOR c_frozen_assignment_exist
755: IS
756: SELECT 'x'
757: FROM xla_line_defn_jlt_assgns s
758: WHERE application_id = p_application_id
759: AND amb_context_code = p_amb_context_code
760: AND event_class_code = p_event_class_code
761: AND accounting_line_type_code = p_accounting_line_type_code

Line 1364: FROM xla_line_defn_jlt_assgns xjl

1360: , xpa.product_rule_type_code
1361: , xpa.product_rule_code
1362: , xpa.locking_status_flag
1363: , xpa.validation_status_code
1364: FROM xla_line_defn_jlt_assgns xjl
1365: ,xla_aad_line_defn_assgns xal
1366: ,xla_prod_acct_headers xpa
1367: WHERE xpa.application_id = xal.application_id
1368: AND xpa.amb_context_code = xal.amb_context_code

Line 1390: FROM xla_line_defn_jlt_assgns xjl

1386: CURSOR c_update_aads IS
1387: SELECT xal.event_class_code
1388: , xal.product_rule_type_code
1389: , xal.product_rule_code
1390: FROM xla_line_defn_jlt_assgns xjl
1391: ,xla_aad_line_defn_assgns xal
1392: ,xla_prod_acct_headers xpa
1393: ,xla_product_rules_b xpr
1394: WHERE xpr.application_id = xpa.application_id

Line 1471: FROM xla_line_defn_jlt_assgns xjl

1467: AND xld.event_class_code = p_event_class_code
1468: AND xld.validation_status_code <> 'N'
1469: AND EXISTS
1470: (SELECT 1
1471: FROM xla_line_defn_jlt_assgns xjl
1472: WHERE xjl.application_id = p_application_id
1473: AND xjl.amb_context_code = p_amb_context_code
1474: AND xjl.event_class_code = p_event_class_code
1475: AND xjl.accounting_line_type_code = p_accounting_line_type_code

Line 2147: FROM xla_line_defn_jlt_assgns

2143:
2144: CURSOR c_assignment_exist
2145: IS
2146: SELECT event_type_code, line_definition_owner_code, line_definition_code
2147: FROM xla_line_defn_jlt_assgns
2148: WHERE application_id = p_application_id
2149: AND amb_context_code = p_amb_context_code
2150: AND event_class_code = p_event_class_code
2151: AND accounting_line_type_code = p_accounting_line_type_code