DBA Data[Home] [Help]

APPS.ECE_CDMO_UTIL dependencies on RA_TERMS

Line 345: FROM RA_CUSTOMER_TRX RCT, RA_CUST_TRX_TYPES RCTT, RA_TERMS_LINES RTL,

341: MIN(RTL.SEQUENCE_NUM)
342: INTO l_term_id, l_currency_precision, l_payment_schedule_exists, l_type,
343: l_first_installment_code, multiple_installments_flag,
344: maximum_installment_number, l_minimum_installment_number
345: FROM RA_CUSTOMER_TRX RCT, RA_CUST_TRX_TYPES RCTT, RA_TERMS_LINES RTL,
346: RA_TERMS RT, FND_CURRENCIES FC
347: WHERE RCT.CUSTOMER_TRX_ID = get_payment.customer_trx_id
348: AND RCT.INVOICE_CURRENCY_CODE = FC.CURRENCY_CODE
349: AND RCT.CUST_TRX_TYPE_ID = RCTT.CUST_TRX_TYPE_ID

Line 346: RA_TERMS RT, FND_CURRENCIES FC

342: INTO l_term_id, l_currency_precision, l_payment_schedule_exists, l_type,
343: l_first_installment_code, multiple_installments_flag,
344: maximum_installment_number, l_minimum_installment_number
345: FROM RA_CUSTOMER_TRX RCT, RA_CUST_TRX_TYPES RCTT, RA_TERMS_LINES RTL,
346: RA_TERMS RT, FND_CURRENCIES FC
347: WHERE RCT.CUSTOMER_TRX_ID = get_payment.customer_trx_id
348: AND RCT.INVOICE_CURRENCY_CODE = FC.CURRENCY_CODE
349: AND RCT.CUST_TRX_TYPE_ID = RCTT.CUST_TRX_TYPE_ID
350: AND RCT.TERM_ID = RT.TERM_ID (+)

Line 358: FROM RA_TERMS RT, RA_TERMS_LINES RTL

354:
355: xProgress := '2010-40';
356: SELECT NVL(MIN(RTL.RELATIVE_AMOUNT),1), NVL(MIN(RT.BASE_AMOUNT),1)
357: INTO l_term_relative_amount, l_term_base_amount
358: FROM RA_TERMS RT, RA_TERMS_LINES RTL
359: WHERE RT.TERM_ID = l_term_id
360: AND RT.TERM_ID = RTL.TERM_ID
361: AND RTL.SEQUENCE_NUM = get_payment.installment_number;
362:

Line 511: FROM RA_TERMS_LINES_DISCOUNTS

507: DISCOUNT_DAYS,
508: DISCOUNT_DATE,
509: DISCOUNT_DAY_OF_MONTH,
510: DISCOUNT_MONTHS_FORWARD
511: FROM RA_TERMS_LINES_DISCOUNTS
512: WHERE TERM_ID = get_term_discount.term_id
513: AND SEQUENCE_NUM =
514: get_term_discount.term_sequence_number;
515: l_counter NUMBER DEFAULT 1;