반응형
R11에는 SLA가 없다.
모듈명 | 제목 | 내용 |
AP | AP Invoice Interface | select * from ap.ap_invoices_interface t |
AP Invoice Line Interface | select * from ap.AP_INVOICE_LINES_INTERFACE t | |
AP Invoice Header | select * from ap_invoices_all where invoice_num = '송장번호'; | |
AP Invoice Distribution | select * from ap_invoice_distributions_all where invoice_id = INVOICE_ID; | |
AP Accouning Event | select * from ap_accounting_events_all where source_id = INVOICE_ID; | |
AP Accounting Event Header | select * from AP_AE_HEADERS_ALL | |
AP Accounting Event Line | select * from Ap_Ae_lines_all order by creation_date desc; |
반응형
'Oracle EBS' 카테고리의 다른 글
Value Set 데이터 조회 Query (0) | 2023.06.16 |
---|---|
FND_ 관련 테이블 목록 (0) | 2023.06.16 |
AR Table 관련 (0) | 2023.06.16 |
AR Table 관련 (0) | 2023.06.16 |
AP Invoice R12버전 (0) | 2023.06.16 |