DBA Data[Home] [Help]

APPS.ECE_AR_TRANSACTION dependencies on RA_TERMS_LINES

Line 768: ra_terms_lines rtl,

764: Maximum_Installment_Number,
765: l_Minimum_Installment_Number
766: FROM ra_customer_trx rct,
767: ra_cust_trx_types rctt,
768: ra_terms_lines rtl,
769: ra_terms rt,
770: fnd_currencies fc
771: WHERE rct.customer_trx_id = Get_Payment.Customer_Trx_ID
772: AND rct.invoice_currency_code = fc.currency_code

Line 791: 'RA_CUSTOMER_TRX, RA_CUST_TRX_TYPES, RA_TERMS_LINES, RA_TERMS, FND_CURRENCIES' );

787: xProgress,
788: 'INFO',
789: 'PAYMENT SCHEDULE',
790: 'TABLE_NAME',
791: 'RA_CUSTOMER_TRX, RA_CUST_TRX_TYPES, RA_TERMS_LINES, RA_TERMS, FND_CURRENCIES' );
792: END;
793:
794: ec_debug.pl ( 3, 'l_Term_ID: ', l_Term_ID );
795: ec_debug.pl ( 3, 'l_Currency_Precision: ', l_Currency_Precision );

Line 810: ra_terms_lines rtl

806: NVL(MIN(rt.base_amount),1)
807: INTO l_Term_Relative_Amount,
808: l_Term_Base_Amount
809: FROM ra_terms rt,
810: ra_terms_lines rtl
811: WHERE rt.term_id = l_Term_ID
812: AND rt.term_id = rtl.term_id
813: AND rtl.sequence_num = Get_Payment.Installment_Number;
814: EXCEPTION

Line 824: 'RA_TERMS, RA_TERMS_LINES' );

820: xProgress,
821: 'INFO',
822: 'AMOUNT',
823: 'TABLE_NAME',
824: 'RA_TERMS, RA_TERMS_LINES' );
825: END;
826:
827: ec_debug.pl ( 3, 'l_Term_Relative_Amount: ', l_Term_Relative_Amount );
828: ec_debug.pl ( 3, 'l_Term_Base_Amount: ', l_Term_Base_Amount );

Line 1145: FROM ra_terms_lines_discounts

1141: discount_days,
1142: nvl(discount_date,Get_Term_Discount.Invoice_date + discount_days), --Bug 2389231
1143: discount_day_of_month,
1144: discount_months_forward
1145: FROM ra_terms_lines_discounts
1146: WHERE term_id = Get_Term_Discount.Term_ID
1147: AND sequence_num = Get_Term_Discount.Term_Sequence_Number;
1148:
1149: l_Counter NUMBER DEFAULT 1;

Line 1265: 'RA_TERMS_LINES_DISCOUNTS' );

1261: xProgress,
1262: 'INFO',
1263: 'DISCOUNT',
1264: 'TABLE_NAME',
1265: 'RA_TERMS_LINES_DISCOUNTS' );
1266: END IF;
1267:
1268: END IF;
1269: