본문 바로가기

Oracle EBS

AR Table 관련

반응형
모듈명 제목 내용
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