본문 바로가기

Oracle EBS

AP Invoice R11버전

반응형

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