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 534: FROM ra_cust_trx_types cust_type,ra_customer_trx cust_trx

530: p_line_rec.commitment_id <> FND_API.G_MISS_NUM THEN
531: BEGIN
532: SELECT NVL(cust_type.subsequent_trx_type_id,cust_type.cust_trx_type_id)
533: INTO l_cust_trx_type_id
534: FROM ra_cust_trx_types cust_type,ra_customer_trx cust_trx
535: WHERE cust_type.cust_trx_type_id = cust_trx.cust_trx_type_id
536: AND cust_trx.customer_trx_id = p_line_rec.commitment_id;
537:
538: IF l_debug_level > 0 THEN

Line 2481: from ra_customer_trx ratrx

2477: -- commented out the following SQL to replace it with new SQL.
2478: /***
2479: select ratrx.end_date_commitment, ratrx.trx_number
2480: into l_comm_end_date, l_commitment_number
2481: from ra_customer_trx ratrx
2482: where ratrx.customer_trx_id = p_line_rec.commitment_id
2483: and exists
2484: ( Select 1
2485: From ra_cust_trx_types ractt

Line 2511: from ra_customer_trx ratrx

2507: */
2508: begin
2509: select /* MOAC_SQL_CHANGE */ 'Y'
2510: into l_exists
2511: from ra_customer_trx ratrx
2512: where ratrx.bill_to_customer_id in
2513: (select p_line_rec.sold_to_org_id
2514: from sys.dual
2515: union

Line 2565: from ra_customer_trx_all ratrx,

2561: select /* MOAC_SQL_CHANGE */ ratrx.end_date_commitment, ratrx.trx_number,
2562: ratrx.agreement_id, ratrl.inventory_item_id
2563: INTO l_comm_end_date, l_commitment_number,
2564: l_agreement_id, l_inventory_item_id
2565: from ra_customer_trx_all ratrx,
2566: ra_cust_trx_types_all ractt,
2567: ra_customer_trx_lines ratrl
2568: where ractt.type in ('DEP','GUAR')
2569: AND ratrx.cust_trx_type_id = ractt.cust_trx_type_id

Line 2567: ra_customer_trx_lines ratrl

2563: INTO l_comm_end_date, l_commitment_number,
2564: l_agreement_id, l_inventory_item_id
2565: from ra_customer_trx_all ratrx,
2566: ra_cust_trx_types_all ractt,
2567: ra_customer_trx_lines ratrl
2568: where ractt.type in ('DEP','GUAR')
2569: AND ratrx.cust_trx_type_id = ractt.cust_trx_type_id
2570: AND ractt.org_id = p_line_rec.org_id
2571: AND ratrl.org_id =ratrx.org_id