eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_INVOICE_PUB dependencies on RA_CUST_TRX_TYPES_ALL

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