DBA Data[Home] [Help]

APPS.OE_VALIDATE_LINE dependencies on RA_CUSTOMER_TRX_ALL

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