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_DEFINITIONS_PVT dependencies on XLA_LINE_DEFN_AC_ASSGNS

Line 3218: FROM xla_line_defn_ac_assgns adr

3214: AND xal.accounting_line_code = xld.accounting_line_code
3215: AND xal.business_method_code = 'PRIOR_ENTRY'
3216: AND EXISTS
3217: (SELECT 'y'
3218: FROM xla_line_defn_ac_assgns adr
3219: WHERE adr.application_id = xld.application_id
3220: AND adr.amb_context_code = xld.amb_context_code
3221: AND adr.event_class_code = xld.event_class_code
3222: AND adr.event_type_code = xld.event_type_code

Line 5287: FROM xla_line_defn_ac_assgns xac

5283: RETURN BOOLEAN
5284: IS
5285: CURSOR c_invalid_line_ac IS
5286: SELECT distinct xah.analytical_criterion_type_code, xah.analytical_criterion_code
5287: FROM xla_line_defn_ac_assgns xac
5288: ,xla_line_defn_jlt_assgns xjl
5289: ,xla_analytical_hdrs_b xah
5290: WHERE xah.amb_context_code = xac.amb_context_code
5291: AND xah.analytical_criterion_code = xac.analytical_criterion_code

Line 5395: FROM xla_line_defn_ac_assgns xac

5391: RETURN BOOLEAN
5392: IS
5393: CURSOR c_invalid_ac IS
5394: SELECT distinct xac.analytical_criterion_type_code, xac.analytical_criterion_code
5395: FROM xla_line_defn_ac_assgns xac
5396: ,xla_line_defn_jlt_assgns xjl
5397: WHERE xac.application_id = xjl.application_id
5398: AND xac.amb_context_code = xjl.amb_context_code
5399: AND xac.event_class_code = xjl.event_class_code

Line 5508: ,xla_line_defn_ac_assgns xac

5504: CURSOR c_invalid_sources IS
5505: SELECT distinct xas.analytical_criterion_type_code, xas.analytical_criterion_code,
5506: xas.source_code, xas.source_type_code
5507: FROM xla_analytical_sources xas
5508: ,xla_line_defn_ac_assgns xac
5509: ,xla_line_defn_jlt_assgns xjl
5510: ,xla_event_sources xes
5511: WHERE xas.application_id = xac.application_id
5512: AND xas.amb_context_code = xac.amb_context_code

Line 5545: ,xla_line_defn_ac_assgns xac

5541: CURSOR c_der_sources IS
5542: SELECT distinct xas.analytical_criterion_type_code, xas.analytical_criterion_code,
5543: xas.source_code, xas.source_type_code
5544: FROM xla_analytical_sources xas
5545: ,xla_line_defn_ac_assgns xac
5546: ,xla_line_defn_jlt_assgns xjl
5547: WHERE xas.application_id = xac.application_id
5548: AND xas.amb_context_code = xac.amb_context_code
5549: AND xas.event_class_code = xac.event_class_code

Line 11615: FROM xla_line_defn_ac_assgns

11611: AND line_definition_owner_code = p_line_definition_owner_code
11612: AND line_definition_code = p_line_definition_code;
11613:
11614: DELETE
11615: FROM xla_line_defn_ac_assgns
11616: WHERE application_id = p_application_id
11617: AND amb_context_code = p_amb_context_code
11618: AND event_class_code = p_event_class_code
11619: AND event_type_code = p_event_type_code

Line 11736: FROM xla_line_defn_ac_assgns

11732: AND accounting_line_type_code = p_accounting_line_type_code
11733: AND accounting_line_code = p_accounting_line_code;
11734:
11735: DELETE
11736: FROM xla_line_defn_ac_assgns
11737: WHERE application_id = p_application_id
11738: AND amb_context_code = p_amb_context_code
11739: AND event_class_code = p_event_class_code
11740: AND event_type_code = p_event_type_code

Line 12289: INSERT INTO xla_line_defn_ac_assgns

12285: AND line_definition_code = p_old_line_defn_code;
12286:
12287: END IF;
12288:
12289: INSERT INTO xla_line_defn_ac_assgns
12290: (application_id
12291: ,amb_context_code
12292: ,event_class_code
12293: ,event_type_code

Line 12323: FROM xla_line_defn_ac_assgns

12319: ,l_created_by
12320: ,l_last_update_date
12321: ,l_last_updated_by
12322: ,l_last_update_login
12323: FROM xla_line_defn_ac_assgns
12324: WHERE application_id = p_application_id
12325: AND amb_context_code = p_amb_context_code
12326: AND event_class_code = p_event_class_code
12327: AND event_type_code = p_event_type_code

Line 13427: INSERT INTO xla_line_defn_ac_assgns

13423: End If; -- mpa_option_code = 'ACCRUAL'
13424: END IF; -- p_include_adr_assignments = 'Y'
13425:
13426: IF (p_include_ac_assignments = 'Y') THEN
13427: INSERT INTO xla_line_defn_ac_assgns
13428: (application_id
13429: ,amb_context_code
13430: ,event_class_code
13431: ,event_type_code

Line 13461: FROM xla_line_defn_ac_assgns

13457: ,l_created_by
13458: ,l_last_update_date
13459: ,l_last_updated_by
13460: ,l_last_update_login
13461: FROM xla_line_defn_ac_assgns
13462: WHERE application_id = p_application_id
13463: AND amb_context_code = p_amb_context_code
13464: AND event_class_code = p_event_class_code
13465: AND event_type_code = p_event_type_code