[Home] [Help]
1540: ,l.gain_or_loss_flag
1541: FROM xla_ae_headers_gt h
1542: ,xla_ae_lines l
1543: ,gl_code_combinations ccid
1544: ,fnd_currencies fcu
1545: WHERE ccid.code_combination_id(+) = l.code_combination_id
1546: AND l.ae_header_id = h.ae_header_id
1547: AND h.ledger_id = :5
1548: AND l.currency_code = fcu.currency_code(+)
1986: ,gl_suspense_accounts gsa
1987: ,gl_suspense_accounts gsa1
1988: ,gl_suspense_accounts gsa2
1989: ,gl_suspense_accounts gsa3
1990: ,fnd_currencies fcu
1991: WHERE ccid.code_combination_id(+) = l.code_combination_id
1992: AND l.ae_header_id = h.ae_header_id
1993: AND h.ledger_id = :9
1994: AND ccid1.code_combination_id(+) = ccid.alternate_code_combination_id
2525: FROM xla_ae_headers_gt h
2526: ,xla_ae_lines l
2527: ,gl_code_combinations ccid
2528: ,gl_code_combinations ccid1
2529: ,fnd_currencies fcu
2530: WHERE ccid.code_combination_id(+) = l.code_combination_id
2531: AND l.ae_header_id = h.ae_header_id
2532: AND h.ledger_id = :9
2533: AND ccid1.code_combination_id(+) = ccid.alternate_code_combination_id
2867: END
2868: FROM xla_ae_headers h
2869: ,xla_ae_lines l
2870: ,gl_code_combinations ccid
2871: ,fnd_currencies fcu
2872: WHERE ccid.code_combination_id(+) = l.code_combination_id
2873: AND l.ae_header_id = h.ae_header_id
2874: AND l.application_id = h.application_id
2875: AND l.currency_code = fcu.currency_code(+)
4329: ,curr.enabled_flag curr_enabled_flag
4330: ,curr.start_date_active curr_start_date_active
4331: ,curr.end_date_active curr_end_date_active
4332: FROM xla_validation_lines_gt t
4333: LEFT OUTER JOIN fnd_currencies curr
4334: ON curr.currency_code = t.entered_currency_code
4335: WHERE (curr.enabled_flag IS NULL) OR
4336: (curr.enabled_flag = 'N') OR
4337: (t.accounting_date < nvl(curr.start_date_active,t.accounting_date)) OR
6240: ,xlo.rounding_rule_code
6241: INTO l_mau, l_rounding_rule_code
6242: FROM xla_ledger_options xlo
6243: ,gl_ledgers gl
6244: ,fnd_currencies fcu
6245: WHERE xlo.application_id = g_application_id
6246: AND xlo.ledger_id = g_trx_ledger_id
6247: AND gl.ledger_id = g_ledger_id
6248: AND fcu.currency_code = gl.currency_code;
7337: ,xlo.rounding_rule_code
7338: INTO l_mau, l_rounding_rule_code
7339: FROM xla_ledger_options xlo
7340: ,gl_ledgers gl
7341: ,fnd_currencies fcu
7342: WHERE xlo.application_id = g_application_id
7343: AND xlo.ledger_id = g_trx_ledger_id
7344: AND gl.ledger_id = g_ledger_id
7345: AND fcu.currency_code = gl.currency_code;
7695: ,l.balance_type_code
7696: FROM fun_bal_results_gt res
7697: ,xla_validation_lines_gt l
7698: ,gl_code_combinations ccid
7699: ,fnd_currencies fcu
7700: WHERE l.ae_line_num = l.max_ae_line_num
7701: AND l.ae_header_id = res.group_id
7702: AND ccid.code_combination_id= res.ccid
7703: AND res.group_id > 0
7793: ,l.balance_type_code
7794: FROM fun_bal_results_gt res
7795: ,xla_validation_lines_gt l
7796: ,gl_code_combinations ccid
7797: ,fnd_currencies fcu
7798: WHERE l.ae_line_num = l.max_ae_line_num
7799: AND l.balancing_line_type NOT IN (C_LINE_TYPE_IC_BAL_INTRA, C_LINE_TYPE_IC_BAL_INTER)
7800: AND l.ae_header_id = res.group_id * -1
7801: AND ccid.code_combination_id= res.ccid
8264: ,xlo.rounding_rule_code
8265: INTO l_mau, l_rounding_rule_code
8266: FROM xla_ledger_options xlo
8267: ,gl_ledgers gl
8268: ,fnd_currencies fcu
8269: WHERE xlo.application_id = g_application_id
8270: AND xlo.ledger_id = g_trx_ledger_id
8271: AND gl.ledger_id = g_ledger_id
8272: AND fcu.currency_code = gl.currency_code;
8984: ,xlo.rounding_rule_code
8985: INTO l_mau, l_rounding_rule_code
8986: FROM xla_ledger_options xlo
8987: ,gl_ledgers gl
8988: ,fnd_currencies fcu
8989: WHERE xlo.application_id = g_application_id
8990: AND xlo.ledger_id = g_trx_ledger_id
8991: AND gl.ledger_id = g_ledger_id
8992: AND fcu.currency_code = gl.currency_code;