반응형
모듈명 | 제목 | 내용 |
AR TRX | AR Transaction Interface | select * from |
AR Transaction | SELECT * FROM ra_customer_trx_all WHERE 1 = 1 AND trx_number = 70006662; |
|
AR Transaction Line | SELECT * FROM ra_customer_trx_lines_all WHERE 1 = 1 AND customer_trx_id = 1913008; |
|
AR Transaction sales person | SELECT * FROM ra_cust_trx_line_salesreps_all WHERE 1 = 1 AND customer_trx_id = 1913008; |
|
AR Transaction Distribution | SELECT * FROM ra_cust_trx_line_gl_dist_all WHERE 1 = 1 AND customer_trx_id = 1913008; |
|
AR Payment Schedule | SELECT * FROM ar_payment_schedules_all WHERE 1 = 1 AND customer_trx_id = 1913008; |
|
AR RCP | AR Receipt | SELECT * FROM ar_cash_receipts_all WHERE 1 = 1 and receipt_number = 'Invoice번호'; |
AR Receipt History | SELECT * FROM ar_cash_receipt_history_all WHERE 1 = 1 and cash_receipt_id = 1203015; |
|
AR Receivable Applications 반제처리 내역 |
SELECT * FROM ar_receivable_applications_all WHERE 1 = 1 and cash_receipt_id = 1203015; |
반응형
'Oracle EBS' 카테고리의 다른 글
Value Set 데이터 조회 Query (0) | 2023.06.16 |
---|---|
FND_ 관련 테이블 목록 (0) | 2023.06.16 |
AR Table 관련 (0) | 2023.06.16 |
AP Invoice R11버전 (1) | 2023.06.16 |
AP Invoice R12버전 (0) | 2023.06.16 |