APPS.OE_DEFAULT_PVT dependencies on RA_CUSTOMER_TRX_ALL

Line 1146: FROM ra_cust_trx_types cust_type,ra_customer_trx_all cust_trx

1142: l_commitment_id <> FND_API.G_MISS_NUM THEN
1143: BEGIN
1144: SELECT NVL(cust_type.subsequent_trx_type_id,cust_type.cust_trx_type_id)
1145: INTO l_cust_trx_type_id
1146: FROM ra_cust_trx_types cust_type,ra_customer_trx_all cust_trx
1147: WHERE cust_type.cust_trx_type_id = cust_trx.cust_trx_type_id
1148: AND cust_trx.customer_trx_id = l_commitment_id;
1149:
1150: IF l_debug_level > 0 THEN

Line 1406: FROM ra_customer_trx_all ratrx,

1402:
1403: --Bug 3247840 fix query for better performance
1404: SELECT /* MOAC_SQL_CHANGE */ customer_trx_id
1405: INTO l_Commitment_id
1406: FROM ra_customer_trx_all ratrx,
1407: ra_cust_trx_types ractt
1408: WHERE ractt.type in ('DEP','GUAR')
1409: AND ratrx.cust_trx_type_id = ractt.cust_trx_type_id
1410: AND ratrx.org_id = ractt.org_id

Line 1424: FROM ra_customer_trx_all ratrx,

1420: UNION ALL /* Peformance changes for sql id 14882692 */
1421:
1422: SELECT /* MOAC_SQL_CHANGE */ customer_trx_id
1423: --INTO l_Commitment_id
1424: FROM ra_customer_trx_all ratrx,
1425: ra_cust_trx_types ractt
1426: WHERE ractt.type in ('DEP','GUAR')
1427: AND ratrx.cust_trx_type_id = ractt.cust_trx_type_id
1428: AND ratrx.org_id = ractt.org_id