APPS.OE_INVOICE_PUB dependencies on RA_CUSTOMER_TRX_ALL

Line 1038: ra_customer_trx_all ct,

1034: SELECT nvl(ctt.credit_memo_type_id, 0),
1035: ctt_credit.creation_sign
1036: INTO x_credit_memo_type_id, x_credit_creation_sign
1037: FROM ra_customer_trx_lines_all ctl,
1038: ra_customer_trx_all ct,
1039: ra_cust_trx_types_all ctt,
1040: ra_cust_trx_types_all ctt_credit
1041: WHERE ctl.customer_trx_line_id = p_line_rec.reference_customer_trx_line_id
1042: AND ct.customer_trx_id = ctl.customer_trx_id

Line 6478: FROM ra_cust_trx_types cust_type,ra_customer_trx_all cust_trx /* MOAC SQL CHANGE */

6474: oe_debug_pub.add( 'GETTING CUST_TRX_TYPE_ID FROM COMMITMENT: '||P_LINE_REC.COMMITMENT_ID , 5 ) ;
6475: END IF;
6476: SELECT NVL(cust_type.subsequent_trx_type_id,cust_type.cust_trx_type_id)
6477: INTO p_x_interface_line_rec.Cust_Trx_Type_Id
6478: FROM ra_cust_trx_types cust_type,ra_customer_trx_all cust_trx /* MOAC SQL CHANGE */
6479: WHERE cust_type.cust_trx_type_id = cust_trx.cust_trx_type_id
6480: AND cust_trx.customer_trx_id = p_line_rec.Commitment_Id;
6481: IF l_debug_level > 0 THEN
6482: oe_debug_pub.add( 'CUST_TRX_TYPE_ID FROM COMMITMENT IS '||P_X_INTERFACE_LINE_REC.CUST_TRX_TYPE_ID ) ;