AR_PAYMENT_TERM_S

Details

Schema: FUSION
Object owner: AR
Object type: VIEW

Columns

Name
PMT_TERM_GLOBAL_ATTR1 PMT_TERM_GLOBAL_ATTR10 PMT_TERM_GLOBAL_ATTR11 PMT_TERM_GLOBAL_ATTR12 PMT_TERM_GLOBAL_ATTR13 PMT_TERM_GLOBAL_ATTR14 PMT_TERM_GLOBAL_ATTR15 PMT_TERM_GLOBAL_ATTR16 PMT_TERM_GLOBAL_ATTR17 PMT_TERM_GLOBAL_ATTR18 PMT_TERM_GLOBAL_ATTR19 PMT_TERM_GLOBAL_ATTR2 PMT_TERM_GLOBAL_ATTR20 PMT_TERM_GLOBAL_ATTR3 PMT_TERM_GLOBAL_ATTR4 PMT_TERM_GLOBAL_ATTR5 PMT_TERM_GLOBAL_ATTR6 PMT_TERM_GLOBAL_ATTR7 PMT_TERM_GLOBAL_ATTR8 PMT_TERM_GLOBAL_ATTR9 PMT_TERM_GLOBAL_ATTR_NUM1 PMT_TERM_GLOBAL_ATTR_NUM2 PMT_TERM_GLOBAL_ATTR_NUM3 PMT_TERM_GLOBAL_ATTR_NUM4 PMT_TERM_GLOBAL_ATTR_NUM5 PMT_TERM_GLOBAL_ATTR_DATE1 PMT_TERM_GLOBAL_ATTR_DATE2 PMT_TERM_GLOBAL_ATTR_DATE3 PMT_TERM_GLOBAL_ATTR_DATE4 PMT_TERM_GLOBAL_ATTR_DATE5 PMT_TERM_GLOBAL_ATTR_CAT PMT_TERM_ID EVENT_ID LINE_NUMBER LANGUAGE LEDGER_ID PMT_TERMS_SEQUENCE_NUMBER

Name

PMT_TERM_GLOBAL_ATTR1

PMT_TERM_GLOBAL_ATTR10

PMT_TERM_GLOBAL_ATTR11

PMT_TERM_GLOBAL_ATTR12

PMT_TERM_GLOBAL_ATTR13

PMT_TERM_GLOBAL_ATTR14

PMT_TERM_GLOBAL_ATTR15

PMT_TERM_GLOBAL_ATTR16

PMT_TERM_GLOBAL_ATTR17

PMT_TERM_GLOBAL_ATTR18

PMT_TERM_GLOBAL_ATTR19

PMT_TERM_GLOBAL_ATTR2

PMT_TERM_GLOBAL_ATTR20

PMT_TERM_GLOBAL_ATTR3

PMT_TERM_GLOBAL_ATTR4

PMT_TERM_GLOBAL_ATTR5

PMT_TERM_GLOBAL_ATTR6

PMT_TERM_GLOBAL_ATTR7

PMT_TERM_GLOBAL_ATTR8

PMT_TERM_GLOBAL_ATTR9

PMT_TERM_GLOBAL_ATTR_NUM1

PMT_TERM_GLOBAL_ATTR_NUM2

PMT_TERM_GLOBAL_ATTR_NUM3

PMT_TERM_GLOBAL_ATTR_NUM4

PMT_TERM_GLOBAL_ATTR_NUM5

PMT_TERM_GLOBAL_ATTR_DATE1

PMT_TERM_GLOBAL_ATTR_DATE2

PMT_TERM_GLOBAL_ATTR_DATE3

PMT_TERM_GLOBAL_ATTR_DATE4

PMT_TERM_GLOBAL_ATTR_DATE5

PMT_TERM_GLOBAL_ATTR_CAT

PMT_TERM_ID

EVENT_ID

LINE_NUMBER

LANGUAGE

LEDGER_ID

PMT_TERMS_SEQUENCE_NUMBER

Query

SQL_Statement
SELECT /+INDEX(l ar_xla_lines_extract_n1)/ ptf.global_attribute1 pmt_term_global_attr1 ,ptf.global_attribute10 pmt_term_global_attr10 ,ptf.global_attribute11 pmt_term_global_attr11 ,ptf.global_attribute12 pmt_term_global_attr12 ,ptf.global_attribute13 pmt_term_global_attr13 ,ptf.global_attribute14 pmt_term_global_attr14 ,ptf.global_attribute15 pmt_term_global_attr15 ,ptf.global_attribute16 pmt_term_global_attr16 ,ptf.global_attribute17 pmt_term_global_attr17 ,ptf.global_attribute18 pmt_term_global_attr18 ,ptf.global_attribute19 pmt_term_global_attr19 ,ptf.global_attribute2 pmt_term_global_attr2 ,ptf.global_attribute20 pmt_term_global_attr20 ,ptf.global_attribute3 pmt_term_global_attr3 ,ptf.global_attribute4 pmt_term_global_attr4 ,ptf.global_attribute5 pmt_term_global_attr5 ,ptf.global_attribute6 pmt_term_global_attr6 ,ptf.global_attribute7 pmt_term_global_attr7 ,ptf.global_attribute8 pmt_term_global_attr8 ,ptf.global_attribute9 pmt_term_global_attr9 ,ptf.global_attribute_number1 pmt_term_global_attr_num1 ,ptf.global_attribute_number2 pmt_term_global_attr_num2 ,ptf.global_attribute_number3 pmt_term_global_attr_num3 ,ptf.global_attribute_number4 pmt_term_global_attr_num4 ,ptf.global_attribute_number5 pmt_term_global_attr_num5 ,ptf.global_attribute_date1 pmt_term_global_attr_date1 ,ptf.global_attribute_date2 pmt_term_global_attr_date2 ,ptf.global_attribute_date3 pmt_term_global_attr_date3 ,ptf.global_attribute_date4 pmt_term_global_attr_date4 ,ptf.global_attribute_date5 pmt_term_global_attr_date5 ,ptf.global_attribute_category pmt_term_global_attr_cat ,tbf.term_id pmt_term_id ,l.event_id event_id ,l.line_number line_number ,l.language language ,l.ledger_id ledger_id ,ptf.terms_sequence_number pmt_terms_sequence_number FROM ar_payment_schedules_all ptf ,ra_terms_b tbf ,ar_xla_lines_extract l WHERE ptf.payment_schedule_id = l.payment_schedule_id AND tbf.term_id (+) = ptf.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)*/ ptf.global_attribute1 pmt_term_global_attr1 ,ptf.global_attribute10 pmt_term_global_attr10 ,ptf.global_attribute11 pmt_term_global_attr11 ,ptf.global_attribute12 pmt_term_global_attr12 ,ptf.global_attribute13 pmt_term_global_attr13 ,ptf.global_attribute14 pmt_term_global_attr14 ,ptf.global_attribute15 pmt_term_global_attr15 ,ptf.global_attribute16 pmt_term_global_attr16 ,ptf.global_attribute17 pmt_term_global_attr17 ,ptf.global_attribute18 pmt_term_global_attr18 ,ptf.global_attribute19 pmt_term_global_attr19 ,ptf.global_attribute2 pmt_term_global_attr2 ,ptf.global_attribute20 pmt_term_global_attr20 ,ptf.global_attribute3 pmt_term_global_attr3 ,ptf.global_attribute4 pmt_term_global_attr4 ,ptf.global_attribute5 pmt_term_global_attr5 ,ptf.global_attribute6 pmt_term_global_attr6 ,ptf.global_attribute7 pmt_term_global_attr7 ,ptf.global_attribute8 pmt_term_global_attr8 ,ptf.global_attribute9 pmt_term_global_attr9 ,ptf.global_attribute_number1 pmt_term_global_attr_num1 ,ptf.global_attribute_number2 pmt_term_global_attr_num2 ,ptf.global_attribute_number3 pmt_term_global_attr_num3 ,ptf.global_attribute_number4 pmt_term_global_attr_num4 ,ptf.global_attribute_number5 pmt_term_global_attr_num5 ,ptf.global_attribute_date1 pmt_term_global_attr_date1 ,ptf.global_attribute_date2 pmt_term_global_attr_date2 ,ptf.global_attribute_date3 pmt_term_global_attr_date3 ,ptf.global_attribute_date4 pmt_term_global_attr_date4 ,ptf.global_attribute_date5 pmt_term_global_attr_date5 ,ptf.global_attribute_category pmt_term_global_attr_cat ,tbf.term_id pmt_term_id ,l.event_id event_id ,l.line_number line_number ,l.language language ,l.ledger_id ledger_id ,ptf.terms_sequence_number pmt_terms_sequence_number FROM ar_payment_schedules_all ptf ,ra_terms_b tbf ,ar_xla_lines_extract l WHERE ptf.payment_schedule_id = l.payment_schedule_id AND tbf.term_id (+) = ptf.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'))