[Home] [Help]
24: ,fia1.ccid CCID
25: ,fia1.type ACCT_TYPE
26: ,gl1.accounted_period_type ACCOUNTED_PERIOD_TYPE
27: ,gl1.period_set_name PERIOD_SET_NAME
28: FROM fun_inter_accounts_v fia1,
29: fun_inter_accounts_v fia2,
30: gl_ledger_le_v gl1,
31: gl_ledger_le_v gl2
32: WHERE fia1.ledger_id = gl1.ledger_id
25: ,fia1.type ACCT_TYPE
26: ,gl1.accounted_period_type ACCOUNTED_PERIOD_TYPE
27: ,gl1.period_set_name PERIOD_SET_NAME
28: FROM fun_inter_accounts_v fia1,
29: fun_inter_accounts_v fia2,
30: gl_ledger_le_v gl1,
31: gl_ledger_le_v gl2
32: WHERE fia1.ledger_id = gl1.ledger_id
33: AND fia1.from_le_id = gl1.legal_entity_id
56: ,gl2.ledger_name TRADING_PARTNER_LEDGER
57: ,glb1.currency_code TRANSACTION_CURRENCY
58: ,glb1.period_name TRANSACTING_PERIOD_NAME
59: ,glp2.period_name TRADING_PERIOD_NAME
60: FROM fun_inter_accounts_v fia1,
61: gl_balances glb1,
62: gl_ledger_le_v gl1,
63: gl_periods glp1,
64: fun_inter_accounts_v fia2,
60: FROM fun_inter_accounts_v fia1,
61: gl_balances glb1,
62: gl_ledger_le_v gl1,
63: gl_periods glp1,
64: fun_inter_accounts_v fia2,
65: gl_ledger_le_v gl2,
66: gl_periods glp2
67: WHERE fia1.ledger_id = glb1.ledger_id
68: AND fia1.ccid = glb1.code_combination_id
398: ,gl_je_lines gjl
399: ,gl_je_headers gjh
400: ,gl_je_batches gjb
401: ,gl_ledger_le_v glv
402: ,fun_inter_accounts_v fia
403: ,gl_periods glp
404: ,xla_subledgers xsrc
405: WHERE aeh.accounting_entry_status_code = ''F''
406: AND aeh.gl_transfer_status_code = ''Y''
535: ,gl_je_lines gjl
536: ,gl_je_headers gjh
537: ,gl_je_batches gjb
538: ,gl_ledger_le_v glv
539: ,fun_inter_accounts_v fia
540: ,gl_periods glp
541: WHERE gjh.je_header_id = gjl.je_header_id
542: AND gjb.je_batch_id = gjh.je_batch_id
543: AND gjb.status = ''P''
586: ,gl_je_lines gjl
587: ,gl_je_headers gjh
588: ,gl_je_batches gjb
589: ,gl_ledger_le_v glv
590: ,fun_inter_accounts_v fia
591: ,gl_periods glp
592: ,xla_ae_headers aeh
593: ,xla_ae_lines ael
594: ,xla_events xle
788: ,gl_je_lines gjl
789: ,gl_je_headers gjh
790: ,gl_je_batches gjb
791: ,gl_ledger_le_v glv
792: ,fun_inter_accounts_v fia
793: ,gl_periods glp
794: WHERE gjh.je_header_id = gjl.je_header_id
795: AND gjb.je_batch_id = gjh.je_batch_id
796: AND gjb.status = ''P''
1940: AND glb.ledger_id = p_trans_ledger_id
1941: AND glb.actual_flag = 'A'
1942: AND glb.currency_code = p_currency
1943: AND glb.code_combination_id IN (SELECT DISTINCT fia.ccid
1944: FROM fun_inter_accounts_v fia
1945: WHERE fia.ledger_id = p_trans_ledger_id
1946: AND fia.from_le_id = p_trans_le_id
1947: AND fia.to_le_id = p_trad_le_id
1948: AND fia.type = 'R' );
1956: AND glb.ledger_id = p_trad_ledger_id
1957: AND glb.actual_flag = 'A'
1958: AND glb.currency_code = p_currency
1959: AND glb.code_combination_id IN (SELECT DISTINCT fia.ccid
1960: FROM fun_inter_accounts_v fia
1961: WHERE fia.ledger_id = p_trad_ledger_id
1962: AND fia.from_le_id = p_trad_le_id
1963: AND fia.to_le_id = p_trans_le_id
1964: AND fia.type = 'P' );
2105: ,gl_je_lines gjl
2106: ,gl_je_headers gjh
2107: ,gl_je_batches gjb
2108: ,gl_ledger_le_v glv
2109: ,fun_inter_accounts_v fia
2110: ,gl_periods glp
2111:
2112: WHERE aeh.accounting_entry_status_code = 'F'
2113: AND aeh.gl_transfer_status_code = 'Y'
2154: ,gl_je_lines gjl
2155: ,gl_je_headers gjh
2156: ,gl_je_batches gjb
2157: ,gl_ledger_le_v glv
2158: ,fun_inter_accounts_v fia
2159: ,gl_periods glp
2160:
2161: WHERE aeh.accounting_entry_status_code = 'F'
2162: AND aeh.gl_transfer_status_code = 'Y'
2206: ,gl_je_lines gjl
2207: ,gl_je_headers gjh
2208: ,gl_je_batches gjb
2209: ,gl_ledger_le_v glv
2210: ,fun_inter_accounts_v fia
2211: ,gl_periods glp
2212:
2213: WHERE aeh.accounting_entry_status_code = 'F'
2214: AND aeh.gl_transfer_status_code = 'Y'
2254: ,gl_je_lines gjl
2255: ,gl_je_headers gjh
2256: ,gl_je_batches gjb
2257: ,gl_ledger_le_v glv
2258: ,fun_inter_accounts_v fia
2259: ,gl_periods glp
2260:
2261: WHERE aeh.accounting_entry_status_code = 'F'
2262: AND aeh.gl_transfer_status_code = 'Y'