APPS.OE_INVOICE_PUB dependencies on RA_CUSTOMER_TRX_ALL

Line 823: ra_customer_trx_all ct,

819: SELECT nvl(ctt.credit_memo_type_id, 0),
820: ctt_credit.creation_sign
821: INTO x_credit_memo_type_id, x_credit_creation_sign
822: FROM ra_customer_trx_lines_all ctl,
823: ra_customer_trx_all ct,
824: ra_cust_trx_types_all ctt,
825: ra_cust_trx_types_all ctt_credit
826: WHERE ctl.customer_trx_line_id = p_line_rec.reference_customer_trx_line_id
827: AND ct.customer_trx_id = ctl.customer_trx_id

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

6216: oe_debug_pub.add( 'GETTING CUST_TRX_TYPE_ID FROM COMMITMENT: '||P_LINE_REC.COMMITMENT_ID , 5 ) ;
6217: END IF;
6218: SELECT NVL(cust_type.subsequent_trx_type_id,cust_type.cust_trx_type_id)
6219: INTO p_x_interface_line_rec.Cust_Trx_Type_Id
6220: FROM ra_cust_trx_types cust_type,ra_customer_trx_all cust_trx /* MOAC SQL CHANGE */
6221: WHERE cust_type.cust_trx_type_id = cust_trx.cust_trx_type_id
6222: AND cust_trx.customer_trx_id = p_line_rec.Commitment_Id;
6223: IF l_debug_level > 0 THEN
6224: oe_debug_pub.add( 'CUST_TRX_TYPE_ID FROM COMMITMENT IS '||P_X_INTERFACE_LINE_REC.CUST_TRX_TYPE_ID ) ;