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_ACCT_ATTRIBUTES_B

Line 3860: xla_acct_attributes_b xaab

3856: xld.accounting_line_type_code, xld.accounting_line_code,
3857: xco.source_type_code, xco.source_code
3858: ,xco.accounting_attribute_code
3859: FROM xla_jlt_acct_attrs xco, xla_line_defn_jlt_assgns xld,
3860: xla_acct_attributes_b xaab
3861: WHERE xld.application_id = p_application_id
3862: AND xld.amb_context_code = p_amb_context_code
3863: AND xld.event_class_code = p_event_class_code
3864: AND xld.event_type_code = p_event_type_code

Line 4065: FROM xla_acct_attributes_b xaa

4061: AND xld.line_definition_owner_code= p_line_definition_owner_code
4062: AND xld.line_definition_code = p_line_definition_code
4063: AND xja.source_code is null
4064: AND EXISTS (SELECT 'x'
4065: FROM xla_acct_attributes_b xaa
4066: WHERE xaa.accounting_attribute_code = xja.accounting_attribute_code
4067: AND xaa.assignment_required_code = 'Y'
4068: AND xaa.assignment_level_code IN ('EVT_CLASS_JLT','JLT_ONLY'));
4069:

Line 4094: FROM xla_acct_attributes_b xaa

4090: AND xld.line_definition_owner_code= p_line_definition_owner_code
4091: AND xld.line_definition_code = p_line_definition_code
4092: AND xja.source_code is null
4093: AND EXISTS (SELECT 'x'
4094: FROM xla_acct_attributes_b xaa
4095: WHERE xaa.accounting_attribute_code = xja.accounting_attribute_code
4096: AND xaa.assignment_required_code = 'Y'
4097: AND xaa.assignment_level_code IN ('EVT_CLASS_JLT','JLT_ONLY')
4098: AND xaa.inherited_flag = 'N');

Line 4239: FROM xla_jlt_acct_attrs xja, xla_acct_attributes_b xaa

4235:
4236: CURSOR c_mapping_groups(l_accounting_line_type_code VARCHAR2
4237: ,l_accounting_line_code VARCHAR2) IS
4238: SELECT distinct xaa.assignment_group_code
4239: FROM xla_jlt_acct_attrs xja, xla_acct_attributes_b xaa
4240: WHERE xja.application_id = p_application_id
4241: AND xja.amb_context_code = p_amb_context_code
4242: AND xja.event_class_code = p_event_class_code
4243: AND xja.accounting_line_type_code = l_accounting_line_type_code

Line 4249: FROM xla_evt_class_acct_attrs xec, xla_acct_attributes_b xaa

4245: AND xja.accounting_attribute_code = xaa.accounting_attribute_code
4246: AND xja.source_code IS NOT NULL
4247: UNION
4248: SELECT distinct xaa.assignment_group_code
4249: FROM xla_evt_class_acct_attrs xec, xla_acct_attributes_b xaa
4250: WHERE xec.application_id = p_application_id
4251: AND xec.event_class_code = p_event_class_code
4252: AND xec.accounting_attribute_code = xaa.accounting_attribute_code
4253: AND xaa.assignment_level_code = 'EVT_CLASS_ONLY'

Line 4260: FROM xla_acct_attributes_b xaa

4256: CURSOR c_group_acct_sources(l_accounting_line_type_code VARCHAR2
4257: ,l_accounting_line_code VARCHAR2
4258: ,l_assignment_group_code VARCHAR2) IS
4259: SELECT distinct xaa.accounting_attribute_code
4260: FROM xla_acct_attributes_b xaa
4261: ,xla_jlt_acct_attrs xja
4262: WHERE xaa.assignment_level_code = 'EVT_CLASS_JLT'
4263: AND xaa.assignment_required_code = 'G'
4264: AND xaa.accounting_attribute_code = xja.accounting_attribute_code

Line 4276: FROM xla_jlt_acct_attrs xja, xla_acct_attributes_b xaa

4272:
4273: CURSOR c_pe_mapping_groups(l_accounting_line_type_code VARCHAR2
4274: ,l_accounting_line_code VARCHAR2) IS
4275: SELECT distinct xaa.assignment_group_code
4276: FROM xla_jlt_acct_attrs xja, xla_acct_attributes_b xaa
4277: WHERE xja.application_id = p_application_id
4278: AND xja.amb_context_code = p_amb_context_code
4279: AND xja.event_class_code = p_event_class_code
4280: AND xja.accounting_line_type_code = l_accounting_line_type_code

Line 4287: FROM xla_evt_class_acct_attrs xec, xla_acct_attributes_b xaa

4283: AND (xja.source_code IS NOT NULL
4284: OR xaa.inherited_flag = 'Y')
4285: UNION
4286: SELECT distinct xaa.assignment_group_code
4287: FROM xla_evt_class_acct_attrs xec, xla_acct_attributes_b xaa
4288: WHERE xec.application_id = p_application_id
4289: AND xec.event_class_code = p_event_class_code
4290: AND xec.accounting_attribute_code = xaa.accounting_attribute_code
4291: AND xaa.assignment_level_code = 'EVT_CLASS_ONLY'

Line 4298: FROM xla_acct_attributes_b xaa

4294: CURSOR c_pe_group_acct_sources(l_accounting_line_type_code VARCHAR2
4295: ,l_accounting_line_code VARCHAR2
4296: ,l_assignment_group_code VARCHAR2) IS
4297: SELECT distinct xaa.accounting_attribute_code
4298: FROM xla_acct_attributes_b xaa
4299: ,xla_jlt_acct_attrs xja
4300: WHERE xaa.assignment_level_code = 'EVT_CLASS_JLT'
4301: AND xaa.assignment_required_code = 'G'
4302: AND xaa.accounting_attribute_code = xja.accounting_attribute_code

Line 4315: FROM xla_acct_attributes_b xaa

4311:
4312: CURSOR c_bus_flow_acct_sources(l_accounting_line_type_code VARCHAR2
4313: ,l_accounting_line_code VARCHAR2) IS
4314: SELECT distinct xaa.accounting_attribute_code
4315: FROM xla_acct_attributes_b xaa
4316: ,xla_jlt_acct_attrs xja
4317: WHERE xaa.assignment_level_code = 'EVT_CLASS_JLT'
4318: AND xaa.assignment_required_code = 'G'
4319: AND xaa.accounting_attribute_code = xja.accounting_attribute_code

Line 4331: FROM xla_acct_attributes_b xaa

4327:
4328: CURSOR c_mpa_acct_sources(l_accounting_line_type_code VARCHAR2
4329: ,l_accounting_line_code VARCHAR2) IS
4330: SELECT distinct xaa.accounting_attribute_code
4331: FROM xla_acct_attributes_b xaa
4332: ,xla_jlt_acct_attrs xja
4333: WHERE xaa.assignment_level_code = 'EVT_CLASS_JLT'
4334: AND xaa.assignment_required_code = 'G'
4335: AND xaa.accounting_attribute_code = xja.accounting_attribute_code

Line 6701: FROM xla_acct_attributes_b xaa

6697: AND xld1.line_definition_code = mpa.line_definition_code
6698: AND xld1.accounting_line_type_code = mpa.mpa_accounting_line_type_code
6699: AND xld1.accounting_line_code = mpa.mpa_accounting_line_code)
6700: AND EXISTS (SELECT 'x'
6701: FROM xla_acct_attributes_b xaa
6702: WHERE xaa.accounting_attribute_code = xja.accounting_attribute_code
6703: AND xaa.assignment_required_code = 'Y'
6704: AND xaa.assignment_level_code IN ('EVT_CLASS_JLT','JLT_ONLY'));
6705:

Line 6752: FROM xla_acct_attributes_b xaa

6748: AND xld1.line_definition_code = mpa.line_definition_code
6749: AND xld1.accounting_line_type_code = mpa.mpa_accounting_line_type_code
6750: AND xld1.accounting_line_code = mpa.mpa_accounting_line_code)
6751: AND EXISTS (SELECT 'x'
6752: FROM xla_acct_attributes_b xaa
6753: WHERE xaa.accounting_attribute_code = xja.accounting_attribute_code
6754: AND xaa.assignment_required_code = 'Y'
6755: AND xaa.assignment_level_code IN ('EVT_CLASS_JLT','JLT_ONLY')
6756: AND xaa.inherited_flag = 'N');

Line 6917: FROM xla_jlt_acct_attrs xja, xla_acct_attributes_b xaa

6913:
6914: CURSOR c_mapping_groups(l_accounting_line_type_code VARCHAR2
6915: ,l_accounting_line_code VARCHAR2) IS
6916: SELECT distinct xaa.assignment_group_code
6917: FROM xla_jlt_acct_attrs xja, xla_acct_attributes_b xaa
6918: WHERE xja.application_id = p_application_id
6919: AND xja.amb_context_code = p_amb_context_code
6920: AND xja.event_class_code = p_event_class_code
6921: AND xja.accounting_line_type_code = l_accounting_line_type_code

Line 6927: FROM xla_evt_class_acct_attrs xec, xla_acct_attributes_b xaa

6923: AND xja.accounting_attribute_code = xaa.accounting_attribute_code
6924: AND xja.source_code IS NOT NULL
6925: UNION
6926: SELECT distinct xaa.assignment_group_code
6927: FROM xla_evt_class_acct_attrs xec, xla_acct_attributes_b xaa
6928: WHERE xec.application_id = p_application_id
6929: AND xec.event_class_code = p_event_class_code
6930: AND xec.accounting_attribute_code = xaa.accounting_attribute_code
6931: AND xaa.assignment_level_code = 'EVT_CLASS_ONLY'

Line 6938: FROM xla_acct_attributes_b xaa

6934: CURSOR c_group_acct_sources(l_accounting_line_type_code VARCHAR2
6935: ,l_accounting_line_code VARCHAR2
6936: ,l_assignment_group_code VARCHAR2) IS
6937: SELECT distinct xaa.accounting_attribute_code
6938: FROM xla_acct_attributes_b xaa
6939: ,xla_jlt_acct_attrs xja
6940: WHERE xaa.assignment_level_code = 'EVT_CLASS_JLT'
6941: AND xaa.assignment_required_code = 'G'
6942: AND xaa.accounting_attribute_code = xja.accounting_attribute_code

Line 6954: FROM xla_jlt_acct_attrs xja, xla_acct_attributes_b xaa

6950:
6951: CURSOR c_pe_mapping_groups(l_accounting_line_type_code VARCHAR2
6952: ,l_accounting_line_code VARCHAR2) IS
6953: SELECT distinct xaa.assignment_group_code
6954: FROM xla_jlt_acct_attrs xja, xla_acct_attributes_b xaa
6955: WHERE xja.application_id = p_application_id
6956: AND xja.amb_context_code = p_amb_context_code
6957: AND xja.event_class_code = p_event_class_code
6958: AND xja.accounting_line_type_code = l_accounting_line_type_code

Line 6965: FROM xla_evt_class_acct_attrs xec, xla_acct_attributes_b xaa

6961: AND (xja.source_code IS NOT NULL
6962: OR xaa.inherited_flag = 'Y')
6963: UNION
6964: SELECT distinct xaa.assignment_group_code
6965: FROM xla_evt_class_acct_attrs xec, xla_acct_attributes_b xaa
6966: WHERE xec.application_id = p_application_id
6967: AND xec.event_class_code = p_event_class_code
6968: AND xec.accounting_attribute_code = xaa.accounting_attribute_code
6969: AND xaa.assignment_level_code = 'EVT_CLASS_ONLY'

Line 6976: FROM xla_acct_attributes_b xaa

6972: CURSOR c_pe_group_acct_sources(l_accounting_line_type_code VARCHAR2
6973: ,l_accounting_line_code VARCHAR2
6974: ,l_assignment_group_code VARCHAR2) IS
6975: SELECT distinct xaa.accounting_attribute_code
6976: FROM xla_acct_attributes_b xaa
6977: ,xla_jlt_acct_attrs xja
6978: WHERE xaa.assignment_level_code = 'EVT_CLASS_JLT'
6979: AND xaa.assignment_required_code = 'G'
6980: AND xaa.accounting_attribute_code = xja.accounting_attribute_code