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_AE_CODE_COMBINATION_PKG dependencies on XLA_TRANSACTION_ACCTS_GT

Line 4143: FROM xla_transaction_accts_gt

4139: , coa_mapping_id
4140: )
4141: SELECT code_combination_id
4142: , sl_coa_mapping_id
4143: FROM xla_transaction_accts_gt
4144: WHERE code_combination_id IS NOT NULL
4145: AND processing_status_code IN (C_MAP_CCID , C_MAP_SEGMENT)
4146: AND sl_coa_mapping_id = p_gl_coa_mapping_id
4147: GROUP BY code_combination_id, sl_coa_mapping_id

Line 4220: SELECT /+ INDEX (XTA XLA_TRANSACTION_ACCTS_GT_N1) LEADING (XTA) /

4216: ,temp.segment29
4217: ,temp.segment30
4218: ,temp.code_combination_status_code) =
4219: (
4220: SELECT /*+ INDEX (XTA XLA_TRANSACTION_ACCTS_GT_N1) LEADING (XTA) */
4221: DISTINCT
4222: DECODE(gami.error_code, NULL, gami.to_ccid, -1)
4223: , nvl(temp.segment1 , gami.to_segment1)
4224: , nvl(temp.segment2 , gami.to_segment2)

Line 4262: , xla_transaction_accts_gt xta

4258: END
4259: ELSE C_INVALID
4260: END
4261: FROM gl_accts_map_int_gt gami
4262: , xla_transaction_accts_gt xta
4263: WHERE xta.ae_header_id = temp.ae_header_id
4264: AND xta.temp_line_num = temp.temp_line_num
4265: AND xta.ledger_id = temp.ledger_id
4266: AND xta.sl_coa_mapping_id = temp.sl_coa_mapping_id

Line 4278: FROM xla_transaction_accts_gt t

4274: WHERE temp.code_combination_id IS NULL
4275: AND temp.sl_coa_mapping_id = p_gl_coa_mapping_id
4276: AND temp.balance_type_code <> 'X'
4277: AND EXISTS (SELECT 'x'
4278: FROM xla_transaction_accts_gt t
4279: WHERE t.ae_header_id = temp.ae_header_id
4280: AND t.temp_line_num = temp.temp_line_num
4281: AND t.ledger_id = temp.ledger_id
4282: AND t.sl_coa_mapping_id = temp.sl_coa_mapping_id

Line 4334: SELECT /+ INDEX (XTA XLA_TRANSACTION_ACCTS_GT_N1) LEADING (XTA) /

4330: ,temp.alt_segment29
4331: ,temp.alt_segment30
4332: ,temp.alt_ccid_status_code) =
4333: (
4334: SELECT /*+ INDEX (XTA XLA_TRANSACTION_ACCTS_GT_N1) LEADING (XTA) */
4335: DISTINCT
4336: DECODE(gami.error_code, NULL, gami.to_ccid, -1)
4337: , nvl(temp.alt_segment1 , gami.to_segment1)
4338: , nvl(temp.alt_segment2 , gami.to_segment2)

Line 4376: , xla_transaction_accts_gt xta

4372: END
4373: ELSE C_INVALID
4374: END
4375: FROM gl_accts_map_int_gt gami
4376: , xla_transaction_accts_gt xta
4377: WHERE xta.ae_header_id = temp.ae_header_id
4378: AND xta.temp_line_num = temp.temp_line_num
4379: AND xta.ledger_id = temp.ledger_id
4380: AND xta.sl_coa_mapping_id = temp.sl_coa_mapping_id

Line 4392: FROM xla_transaction_accts_gt t

4388: WHERE temp.alt_code_combination_id IS NULL
4389: AND temp.sl_coa_mapping_id = p_gl_coa_mapping_id
4390: AND temp.balance_type_code <> 'X'
4391: AND EXISTS (SELECT 'x'
4392: FROM xla_transaction_accts_gt t
4393: WHERE t.ae_header_id = temp.ae_header_id
4394: AND t.temp_line_num = temp.temp_line_num
4395: AND t.ledger_id = temp.ledger_id
4396: AND t.sl_coa_mapping_id = temp.sl_coa_mapping_id

Line 4499: , xla_transaction_accts_gt xta

4495: , l_array_to_segment_code
4496: , l_array_ccid
4497: , l_array_segment_value
4498: FROM gl_code_combinations gami
4499: , xla_transaction_accts_gt xta
4500: WHERE gami.code_combination_id = xta.code_combination_id
4501: AND gami.chart_of_accounts_id = l_from_coa_id
4502: AND xta.code_combination_id IS NOT NULL
4503: AND xta.from_segment_code IS NOT NULL

Line 4563: , xla_transaction_accts_gt xta

4559: , l_array_to_segment_code
4560: , l_array_ccid
4561: , l_array_segment_value
4562: FROM gl_accts_map_int_gt gami
4563: , xla_transaction_accts_gt xta
4564: WHERE gami.from_ccid = xta.code_combination_id
4565: AND gami.coa_mapping_id = xta.sl_coa_mapping_id
4566: AND xta.code_combination_id IS NOT NULL
4567: AND xta.from_segment_code IS NOT NULL

Line 4652: FROM xla_transaction_accts_gt seg

4648: WHEN C_CREATED THEN C_NOT_PROCESSED
4649: ELSE temp.code_combination_status_code
4650: END
4651: END
4652: FROM xla_transaction_accts_gt seg
4653: WHERE seg.ae_header_id = temp.ae_header_id
4654: AND seg.temp_line_num = temp.temp_line_num
4655: AND seg.ledger_id = temp.ledger_id
4656: AND seg.sl_coa_mapping_id = temp.sl_coa_mapping_id

Line 4666: FROM xla_transaction_accts_gt t

4662: AND seg.processing_status_code = l_array_processing_status_code(i)--added for bug6314762 to avoid single row subquery returns more than one row error
4663: )
4664: WHERE temp.balance_type_code <> 'X'
4665: AND EXISTS (SELECT 'x'
4666: FROM xla_transaction_accts_gt t
4667: WHERE t.ae_header_id = temp.ae_header_id
4668: AND t.temp_line_num = temp.temp_line_num
4669: AND t.ledger_id = temp.ledger_id
4670: AND t.sl_coa_mapping_id = temp.sl_coa_mapping_id

Line 4748: , xla_transaction_accts_gt xta

4744: , l_array_alt_to_segment_code
4745: , l_array_alt_ccid
4746: , l_array_alt_segment_value
4747: FROM gl_accts_map_int_gt gami
4748: , xla_transaction_accts_gt xta
4749: WHERE gami.from_ccid = xta.code_combination_id
4750: AND gami.coa_mapping_id = xta.sl_coa_mapping_id
4751: AND xta.code_combination_id IS NOT NULL
4752: AND xta.from_segment_code IS NOT NULL

Line 4836: FROM xla_transaction_accts_gt seg

4832: WHEN C_CREATED THEN C_NOT_PROCESSED
4833: ELSE temp.alt_ccid_status_code
4834: END
4835: END
4836: FROM xla_transaction_accts_gt seg
4837: WHERE seg.ae_header_id = temp.ae_header_id
4838: AND seg.temp_line_num = temp.temp_line_num
4839: AND seg.ledger_id = temp.ledger_id
4840: AND seg.sl_coa_mapping_id = temp.sl_coa_mapping_id

Line 4850: FROM xla_transaction_accts_gt t

4846: AND seg.processing_status_code = l_array_processing_status_code(i)--added by for bug6314762 to avoid single row subquery returns more than one row error
4847: )
4848: WHERE temp.balance_type_code <> 'X'
4849: AND EXISTS (SELECT 'x'
4850: FROM xla_transaction_accts_gt t
4851: WHERE t.ae_header_id = temp.ae_header_id
4852: AND t.temp_line_num = temp.temp_line_num
4853: AND t.ledger_id = temp.ledger_id
4854: AND t.sl_coa_mapping_id = temp.sl_coa_mapping_id

Line 4900: ,xla_transaction_accts_gt xtag

4896: ,xjlg.ccid_coa_id ccid_coa_id
4897: FROM gl_accts_map_int_gt gami
4898: ,xla_ae_lines_gt xjlg
4899: ,xla_ae_headers_gt xahg
4900: ,xla_transaction_accts_gt xtag
4901: WHERE xjlg.ae_header_id = xahg.ae_header_id
4902: AND xjlg.event_id = xahg.event_id
4903: AND xjlg.ae_header_id = xtag.ae_header_id
4904: AND xjlg.temp_line_num = xtag.temp_line_num

Line 4926: ,xla_transaction_accts_gt xtag

4922: , xjlg.ccid_coa_id coa_id
4923: FROM gl_accts_map_int_gt gami
4924: ,xla_ae_lines_gt xjlg
4925: ,xla_ae_headers_gt xahg
4926: ,xla_transaction_accts_gt xtag
4927: WHERE xjlg.ae_header_id = xahg.ae_header_id
4928: AND xjlg.event_id = xahg.event_id
4929: AND xjlg.ae_header_id = xtag.ae_header_id
4930: AND xjlg.temp_line_num = xtag.temp_line_num

Line 5061: FROM xla_transaction_accts_gt xtag

5057:
5058: l_count := 0;
5059:
5060: FOR qualifier_rec IN (SELECT xtag.from_segment_code qualifier
5061: FROM xla_transaction_accts_gt xtag
5062: WHERE xtag.sl_coa_mapping_id = p_gl_coa_mapping_id
5063: AND xtag.processing_status_code = 'MAP_QUALIFIER'
5064: GROUP BY xtag.from_segment_code )
5065: LOOP

Line 5075: FROM xla_transaction_accts_gt xtag

5071:
5072: INSERT INTO gl_accts_map_bsv_gt
5073: ( SOURCE_BSV )
5074: SELECT segment
5075: FROM xla_transaction_accts_gt xtag
5076: WHERE xtag.sl_coa_mapping_id = p_gl_coa_mapping_id
5077: AND xtag.processing_status_code = 'MAP_QUALIFIER'
5078: AND xtag.from_segment_code = qualifier_rec.qualifier
5079: GROUP BY segment

Line 5135: FROM xla_transaction_accts_gt t

5131: SET temp.code_combination_id = -1
5132: ,temp.code_combination_status_code = C_INVALID
5133: WHERE temp.balance_type_code <> 'X'
5134: AND EXISTS (SELECT 'x'
5135: FROM xla_transaction_accts_gt t
5136: WHERE t.ae_header_id = temp.ae_header_id
5137: AND t.temp_line_num = temp.temp_line_num
5138: AND t.ledger_id = temp.ledger_id
5139: AND t.sl_coa_mapping_id = temp.sl_coa_mapping_id

Line 5200: FROM xla_transaction_accts_gt t

5196: SET temp.alt_code_combination_id = -1
5197: ,temp.alt_ccid_status_code = C_INVALID
5198: WHERE temp.balance_type_code <> 'X'
5199: AND EXISTS (SELECT 'x'
5200: FROM xla_transaction_accts_gt t
5201: WHERE t.ae_header_id = temp.ae_header_id
5202: AND t.temp_line_num = temp.temp_line_num
5203: AND t.ledger_id = temp.ledger_id
5204: AND t.sl_coa_mapping_id = temp.sl_coa_mapping_id

Line 5331: , xla_transaction_accts_gt xta

5327: , xta.sl_coa_mapping_id sl_coa_mapping_id
5328: , xta.to_segment_code to_segment_code
5329: , gami.target_bsv target_value
5330: FROM gl_accts_map_bsv_gt gami
5331: , xla_transaction_accts_gt xta
5332: WHERE gami.source_bsv = xta.segment
5333: AND xta.from_segment_code = qualifier_rec.qualifier
5334: AND xta.processing_status_code = 'MAP_QUALIFIER'
5335: AND xta.side_code IN ('ALL','CREDIT','NA')

Line 5345: FROM xla_transaction_accts_gt t

5341: AND seg.sl_coa_mapping_id = temp.sl_coa_mapping_id
5342: )
5343: WHERE temp.balance_type_code <> 'X'
5344: AND EXISTS (SELECT 'x'
5345: FROM xla_transaction_accts_gt t
5346: WHERE t.ae_header_id = temp.ae_header_id
5347: AND t.temp_line_num = temp.temp_line_num
5348: AND t.ledger_id = temp.ledger_id
5349: AND t.sl_coa_mapping_id = temp.sl_coa_mapping_id

Line 5445: , xla_transaction_accts_gt xta

5441: , xta.sl_coa_mapping_id sl_coa_mapping_id
5442: , xta.to_segment_code to_segment_code
5443: , gami.target_bsv target_value
5444: FROM gl_accts_map_bsv_gt gami
5445: , xla_transaction_accts_gt xta
5446: WHERE gami.source_bsv = xta.segment
5447: AND xta.from_segment_code = qualifier_rec.qualifier
5448: AND xta.processing_status_code = 'MAP_QUALIFIER'
5449: AND xta.side_code IN ('ALL','DEBIT')

Line 5459: FROM xla_transaction_accts_gt t

5455: AND seg.sl_coa_mapping_id = temp.sl_coa_mapping_id
5456: )
5457: WHERE temp.balance_type_code <> 'X'
5458: AND EXISTS (SELECT 'x'
5459: FROM xla_transaction_accts_gt t
5460: WHERE t.ae_header_id = temp.ae_header_id
5461: AND t.temp_line_num = temp.temp_line_num
5462: AND t.ledger_id = temp.ledger_id
5463: AND t.sl_coa_mapping_id = temp.sl_coa_mapping_id