APPS.OE_INVOICE_PUB dependencies on RA_CUST_TRX_TYPES_ALL

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 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,