GL_会计科目子模组追溯至总账分析（案例）

 1 select invoice_id from ap_invoices_all
 2 
 3 where invoice_num = 'BXJ20120904_001'
 4 
 5  
 6 
 7 select * from ap_invoice_lines_all
 8 
 9 where invoice_id = 2977123
10 
11  
12 
13 select accounting_event_id from ap_invoice_distributions_all
14 
15 where invoice_id = 2977123
16 
17  
18 
19 select entity_id from xla. xla_events
20 
21 where event_id = 21380679
22 
23  
24 
25 select source_id_int_1, transaction_number from xla.xla_transaction_entities
26 
27 where entity_id = 21028756
28 
29  
30 
31 select * from xla. xla_ae_headers
32 
33 where event_id = 21380679
34 
35  
36 
37 select * from xla. xla_ae_lines
38 
39 where ae_header_id in ( 121331026, 121331041)
40 
41  
42 
43 select * from xla. xla_distribution_links
44 
45 where ae_header_id in ( 121331026, 121331041)
46 
47  
48 
49 select    je_batch_id,
50 
51             je_header_id ,
52 
53             gl_sl_link_id ,
54 
55             gl_sl_link_table ,
56 
57             reference_5 entity_id ,
58 
59             reference_6 accounting_event_id ,
60 
61             reference_7 ae_header_id
62 
63   from   gl_import_references
64 
65  where gl_sl_link_id = 246342532
66 
67  
68 
69 select * from gl_je_lines
70 
71 where je_header_id = 2720705
72 
73 and gl_sl_link_id = 246342532
74 
75  
76 
77 select * from gl_je_batches
78 
79 where je_batch_id = 2694595
80 
81  
82 
83 select * from gl_je_headers
84 
85 whereje_batch_id = 2694595