APPS.OE_INVOICE_PUB dependencies on RA_CUST_TRX_TYPES

Line 1039: ra_cust_trx_types_all ctt,

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

Line 1040: ra_cust_trx_types_all ctt_credit

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

Line 1152: FROM ra_cust_trx_types_all ctt,

1148: BEGIN
1149: SELECT NVL(ctt.credit_memo_type_id, 0),
1150: ctt_credit.creation_sign
1151: INTO x_credit_memo_type_id, x_credit_creation_sign
1152: FROM ra_cust_trx_types_all ctt,
1153: ra_cust_trx_types_all ctt_credit
1154: WHERE ctt.cust_trx_type_id = l_inv_cust_trx_type_id
1155: AND ctt_credit.cust_trx_type_id = ctt.credit_memo_type_id
1156: AND NVL(ctt.org_id, -3114) = NVL(p_line_rec.org_id, -3114)

Line 1153: ra_cust_trx_types_all ctt_credit

1149: SELECT NVL(ctt.credit_memo_type_id, 0),
1150: ctt_credit.creation_sign
1151: INTO x_credit_memo_type_id, x_credit_creation_sign
1152: FROM ra_cust_trx_types_all ctt,
1153: ra_cust_trx_types_all ctt_credit
1154: WHERE ctt.cust_trx_type_id = l_inv_cust_trx_type_id
1155: AND ctt_credit.cust_trx_type_id = ctt.credit_memo_type_id
1156: AND NVL(ctt.org_id, -3114) = NVL(p_line_rec.org_id, -3114)
1157: /* DECODE(ctt.cust_trx_type_id,

Line 1234: FROM ra_cust_trx_types

1230: END IF;
1231: IF p_cust_trx_type_id IS NOT NULL AND p_cust_trx_type_id <> 0 THEN
1232: SELECT creation_sign
1233: INTO l_creation_sign
1234: FROM ra_cust_trx_types
1235: WHERE cust_trx_type_id = p_Cust_Trx_Type_Id;
1236: END IF;
1237: IF l_debug_level > 0 THEN
1238: oe_debug_pub.add( 'CREATION_SIGN: '||L_CREATION_SIGN ) ;

Line 1830: FROM ra_cust_trx_types_all ctt

1826: oe_debug_pub.add( 'GET CREDIT MEMO TYPE ' , 5 ) ;
1827: END IF;
1828: SELECT nvl(ctt.credit_memo_type_id, 0)
1829: INTO l_cust_trx_type_id
1830: FROM ra_cust_trx_types_all ctt
1831: WHERE ctt.cust_trx_type_id = l_inv_cust_trx_type_id
1832: AND NVL(ctt.org_id, -3114) = NVL(p_line_rec.org_id, -3114);
1833: /* DECODE(ctt.cust_trx_type_id,
1834: 1, -3113,

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