APPS.OE_INVOICE_PUB dependencies on RA_CUST_TRX_TYPES

Line 824: ra_cust_trx_types_all ctt,

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
828: AND ctt.cust_trx_type_id = ct.cust_trx_type_id

Line 825: ra_cust_trx_types_all ctt_credit

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
828: AND ctt.cust_trx_type_id = ct.cust_trx_type_id
829: AND ctt_credit.cust_trx_type_id = ctt.credit_memo_type_id

Line 937: FROM ra_cust_trx_types_all ctt,

933: BEGIN
934: SELECT NVL(ctt.credit_memo_type_id, 0),
935: ctt_credit.creation_sign
936: INTO x_credit_memo_type_id, x_credit_creation_sign
937: FROM ra_cust_trx_types_all ctt,
938: ra_cust_trx_types_all ctt_credit
939: WHERE ctt.cust_trx_type_id = l_inv_cust_trx_type_id
940: AND ctt_credit.cust_trx_type_id = ctt.credit_memo_type_id
941: AND NVL(ctt.org_id, -3114) = NVL(p_line_rec.org_id, -3114)

Line 938: ra_cust_trx_types_all ctt_credit

934: SELECT NVL(ctt.credit_memo_type_id, 0),
935: ctt_credit.creation_sign
936: INTO x_credit_memo_type_id, x_credit_creation_sign
937: FROM ra_cust_trx_types_all ctt,
938: ra_cust_trx_types_all ctt_credit
939: WHERE ctt.cust_trx_type_id = l_inv_cust_trx_type_id
940: AND ctt_credit.cust_trx_type_id = ctt.credit_memo_type_id
941: AND NVL(ctt.org_id, -3114) = NVL(p_line_rec.org_id, -3114)
942: /* DECODE(ctt.cust_trx_type_id,

Line 1019: FROM ra_cust_trx_types

1015: END IF;
1016: IF p_cust_trx_type_id IS NOT NULL AND p_cust_trx_type_id <> 0 THEN
1017: SELECT creation_sign
1018: INTO l_creation_sign
1019: FROM ra_cust_trx_types
1020: WHERE cust_trx_type_id = p_Cust_Trx_Type_Id;
1021: END IF;
1022: IF l_debug_level > 0 THEN
1023: oe_debug_pub.add( 'CREATION_SIGN: '||L_CREATION_SIGN ) ;

Line 1613: FROM ra_cust_trx_types_all ctt

1609: oe_debug_pub.add( 'GET CREDIT MEMO TYPE ' , 5 ) ;
1610: END IF;
1611: SELECT nvl(ctt.credit_memo_type_id, 0)
1612: INTO l_cust_trx_type_id
1613: FROM ra_cust_trx_types_all ctt
1614: WHERE ctt.cust_trx_type_id = l_inv_cust_trx_type_id
1615: AND NVL(ctt.org_id, -3114) = NVL(p_line_rec.org_id, -3114);
1616: /* DECODE(ctt.cust_trx_type_id,
1617: 1, -3113,

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 ) ;