APPS.OE_DEFAULT_PVT dependencies on RA_CUST_TRX_TYPES

Line 1120: FROM RA_CUST_TRX_TYPES

1116:
1117: /* Cursor C_tax_calculation_flag is
1118: SELECT tax_calculation_flag
1119: into l_calculate_tax_flag
1120: FROM RA_CUST_TRX_TYPES
1121: WHERE CUST_TRX_TYPE_ID = l_cust_trx_type_id;
1122: */
1123: /* added by Renga for bug 1476390 */
1124: --

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 1182: FROM RA_CUST_TRX_TYPES

1178: l_calculate_tax_flag := OE_ORDER_CACHE.g_line_type_rec.calculate_tax_flag ;
1179: ELSE
1180: SELECT tax_calculation_flag
1181: into l_calculate_tax_flag
1182: FROM RA_CUST_TRX_TYPES
1183: WHERE CUST_TRX_TYPE_ID = l_cust_trx_type_id;
1184: END IF ;
1185: /*if( l_cust_trx_type_id is not NULL or l_cust_trx_type_id <> 0) then
1186: SELECT tax_calculation_flag

Line 1188: FROM RA_CUST_TRX_TYPES

1184: END IF ;
1185: /*if( l_cust_trx_type_id is not NULL or l_cust_trx_type_id <> 0) then
1186: SELECT tax_calculation_flag
1187: into l_calculate_tax_flag
1188: FROM RA_CUST_TRX_TYPES
1189: WHERE CUST_TRX_TYPE_ID = l_cust_trx_type_id;
1190: end if; */
1191: -- end bug 4200055
1192: --l_line_type_rec := oe_order_cache.load_line_type(ONT_LINE_DEF_HDLR.g_record.line_type_id);

Line 1407: ra_cust_trx_types ractt

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
1411: AND ratrx.bill_to_customer_id = ONT_LINE_Def_Hdlr.g_record.sold_to_org_id

Line 1425: ra_cust_trx_types ractt

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
1429: AND ratrx.bill_to_customer_id IN (