eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_VALIDATE_LINE dependencies on RA_CUSTOMER_TRX

Line 541: FROM ra_cust_trx_types cust_type,ra_customer_trx cust_trx

537: p_line_rec.commitment_id <> FND_API.G_MISS_NUM THEN
538: BEGIN
539: SELECT NVL(cust_type.subsequent_trx_type_id,cust_type.cust_trx_type_id)
540: INTO l_cust_trx_type_id
541: FROM ra_cust_trx_types cust_type,ra_customer_trx cust_trx
542: WHERE cust_type.cust_trx_type_id = cust_trx.cust_trx_type_id
543: AND cust_trx.customer_trx_id = p_line_rec.commitment_id;
544:
545: IF l_debug_level > 0 THEN

Line 2606: from ra_customer_trx ratrx

2602: -- commented out the following SQL to replace it with new SQL.
2603: /***
2604: select ratrx.end_date_commitment, ratrx.trx_number
2605: into l_comm_end_date, l_commitment_number
2606: from ra_customer_trx ratrx
2607: where ratrx.customer_trx_id = p_line_rec.commitment_id
2608: and exists
2609: ( Select 1
2610: From ra_cust_trx_types ractt

Line 2636: from ra_customer_trx ratrx

2632: */
2633: begin
2634: select /* MOAC_SQL_CHANGE */ 'Y'
2635: into l_exists
2636: from ra_customer_trx ratrx
2637: where ratrx.bill_to_customer_id in
2638: (select p_line_rec.sold_to_org_id
2639: from sys.dual
2640: union

Line 2690: from ra_customer_trx_all ratrx,

2686: select /* MOAC_SQL_CHANGE */ ratrx.end_date_commitment, ratrx.trx_number,
2687: ratrx.agreement_id, ratrl.inventory_item_id
2688: INTO l_comm_end_date, l_commitment_number,
2689: l_agreement_id, l_inventory_item_id
2690: from ra_customer_trx_all ratrx,
2691: ra_cust_trx_types_all ractt,
2692: ra_customer_trx_lines ratrl
2693: where ractt.type in ('DEP','GUAR')
2694: AND ratrx.cust_trx_type_id = ractt.cust_trx_type_id

Line 2692: ra_customer_trx_lines ratrl

2688: INTO l_comm_end_date, l_commitment_number,
2689: l_agreement_id, l_inventory_item_id
2690: from ra_customer_trx_all ratrx,
2691: ra_cust_trx_types_all ractt,
2692: ra_customer_trx_lines ratrl
2693: where ractt.type in ('DEP','GUAR')
2694: AND ratrx.cust_trx_type_id = ractt.cust_trx_type_id
2695: AND ractt.org_id = p_line_rec.org_id
2696: AND ratrl.org_id =ratrx.org_id