AR_PAYMENT_TERM_S

Details

Schema: FUSION
Object owner: AR
Object type: VIEW

Columns

Name
PMT_TERM_DESCRIPTION PMT_TERM_NAME EVENT_ID LINE_NUMBER LANGUAGE LEDGER_ID

Name

PMT_TERM_DESCRIPTION

PMT_TERM_NAME

EVENT_ID

LINE_NUMBER

LANGUAGE

LEDGER_ID

Query

SQL_Statement
SELECT /+INDEX(l ar_xla_lines_extract_n1)/ tblf.description pmt_term_description ,tblf.name pmt_term_name ,l.event_id event_id ,l.line_number line_number ,tblf.language language ,l.ledger_id ledger_id FROM ra_terms_tl tblf ,ar_xla_lines_extract l WHERE tblf.term_id = l.term_id AND ((l.event_class_code IN ('INVOICE','DEBIT_MEMO','DEPOSIT', 'GUARANTEE','CHARGEBACK','ADJUSTMENT') AND l.level_flag = 'H') OR (l.event_class_code IN ('CREDIT_MEMO','RECEIPT') AND l.level_flag = 'L' AND l.from_to_flag = 'T'))

SQL_Statement

SELECT /*+INDEX(l ar_xla_lines_extract_n1)*/ tblf.description pmt_term_description ,tblf.name pmt_term_name ,l.event_id event_id ,l.line_number line_number ,tblf.language language ,l.ledger_id ledger_id FROM ra_terms_tl tblf ,ar_xla_lines_extract l WHERE tblf.term_id = l.term_id AND ((l.event_class_code IN ('INVOICE','DEBIT_MEMO','DEPOSIT', 'GUARANTEE','CHARGEBACK','ADJUSTMENT') AND l.level_flag = 'H') OR (l.event_class_code IN ('CREDIT_MEMO','RECEIPT') AND l.level_flag = 'L' AND l.from_to_flag = 'T'))