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.ASO_TAX_INT dependencies on RA_CUST_TRX_TYPES

Line 1074: aso_debug_pub.add('Before selecting cust_trx_type_id from ra_cust_trx_types_all table', 1, 'Y');

1070: aso_debug_pub.add('l_hdr_tax_exempt_number: '|| l_hdr_tax_exempt_number, 1, 'Y');
1071: aso_debug_pub.add('l_hdr_tax_exempt_reason_code: '|| l_hdr_tax_exempt_reason_code, 1, 'Y');
1072: aso_debug_pub.add('l_hdr_tax_exempt_flag: '|| l_hdr_tax_exempt_flag, 1, 'Y');
1073:
1074: aso_debug_pub.add('Before selecting cust_trx_type_id from ra_cust_trx_types_all table', 1, 'Y');
1075: aso_debug_pub.add('ASO_TAX_LINE: l_trx_type_id: '|| l_trx_type_id, 1, 'Y');
1076:
1077: END IF;
1078:

Line 1086: --from ra_cust_trx_types_all Commented Code yogeshwar (MOAC)

1082: Begin
1083:
1084: select cust_trx_type_id
1085: into l_ra_cust_trx_type_id
1086: --from ra_cust_trx_types_all Commented Code yogeshwar (MOAC)
1087: from ra_cust_trx_types --New Code Yogeshwar (MOAC)
1088: where cust_trx_type_id = l_trx_type_id
1089: --Commented Code Start Yogeshwar (MOAC)
1090: -- and nvl(org_id,

Line 1087: from ra_cust_trx_types --New Code Yogeshwar (MOAC)

1083:
1084: select cust_trx_type_id
1085: into l_ra_cust_trx_type_id
1086: --from ra_cust_trx_types_all Commented Code yogeshwar (MOAC)
1087: from ra_cust_trx_types --New Code Yogeshwar (MOAC)
1088: where cust_trx_type_id = l_trx_type_id
1089: --Commented Code Start Yogeshwar (MOAC)
1090: -- and nvl(org_id,
1091: -- nvl(to_number(decode(substrb(userenv('CLIENT_INFO'),1 ,1), ' ',null,

Line 1109: l_reason := l_reason || 'from ra_cust_trx_types_all. ';

1105: aso_debug_pub.add('ASO_TAX_LINE: NO_DATA_FOUND when selecting cust_trx_type_id', 1, 'Y');
1106: END IF;
1107:
1108: l_reason := 'No Data Found Exception raised while selecting cust_trx_type_id';
1109: l_reason := l_reason || 'from ra_cust_trx_types_all. ';
1110: l_reason := l_reason || fnd_global.newline();
1111: l_reason := l_reason || 'Please check Default order type id profile is correctly';
1112: l_reason := l_reason || 'set. Also pl verify the';
1113: l_reason := l_reason || fnd_global.newline();

Line 1723: --from ra_cust_trx_types_all ra Commented Code Yogeshwar (MOAC)

1719: end if;
1720:
1721: select oe.transaction_type_id
1722: into l_om_trx_type_id
1723: --from ra_cust_trx_types_all ra Commented Code Yogeshwar (MOAC)
1724: from ra_cust_trx_types ra, --New Code Yogeshwar (MOAC)
1725: oe_transaction_types_vl oe
1726: where ra.cust_trx_type_id = l_trx_type_id
1727: and ra.cust_trx_type_id = oe.cust_trx_type_id

Line 1724: from ra_cust_trx_types ra, --New Code Yogeshwar (MOAC)

1720:
1721: select oe.transaction_type_id
1722: into l_om_trx_type_id
1723: --from ra_cust_trx_types_all ra Commented Code Yogeshwar (MOAC)
1724: from ra_cust_trx_types ra, --New Code Yogeshwar (MOAC)
1725: oe_transaction_types_vl oe
1726: where ra.cust_trx_type_id = l_trx_type_id
1727: and ra.cust_trx_type_id = oe.cust_trx_type_id
1728: and oe.transaction_type_id = nvl(l_qte_line_tbl(i).order_line_type_id, l_qte_header_rec.order_type_id)

Line 1752: l_reason := l_reason || 'ra_cust_trx_types_all and oe_transaction_types_vl';

1748: aso_debug_pub.add('ASO_TAX_LINE: NO_DATA_FOUND when selecting transaction_type_id', 1, 'Y');
1749: END IF;
1750:
1751: l_reason := 'No Data Found Exception when selecting transaction_type_id from ';
1752: l_reason := l_reason || 'ra_cust_trx_types_all and oe_transaction_types_vl';
1753: l_reason := l_reason || fnd_global.newline();
1754: l_reason := l_reason || 'Please check Default order type id profile is ';
1755: l_reason := l_reason || 'correctly set. Also pl verify the';
1756: l_reason := l_reason || fnd_global.newline();

Line 2304: from ra_cust_trx_types

2300: AND quote_header_id=p_qte_header_id;
2301:
2302: Cursor c_cust_trx_type_id(l_trx_type_id NUMBER) is
2303: select cust_trx_type_id
2304: from ra_cust_trx_types
2305: where cust_trx_type_id = l_trx_type_id
2306: and (tax_calculation_flag = 'Y');
2307:
2308: Cursor c_set_of_books_id is

Line 3536: --FROM ra_cust_trx_types_all ctt Commented Code Yogeshwar (MOAC)

3532: END IF;
3533:
3534: SELECT nvl(ctt.credit_memo_type_id, 0)
3535: INTO l_cust_trx_type_id
3536: --FROM ra_cust_trx_types_all ctt Commented Code Yogeshwar (MOAC)
3537: FROM ra_cust_trx_types ctt --New Code Yogeshwar (MOAC)
3538: WHERE ctt.cust_trx_type_id = l_inv_cust_trx_type_id
3539: AND NVL(ctt.org_id, -3114) = DECODE(ctt.cust_trx_type_id,
3540: 1, -3113,

Line 3537: FROM ra_cust_trx_types ctt --New Code Yogeshwar (MOAC)

3533:
3534: SELECT nvl(ctt.credit_memo_type_id, 0)
3535: INTO l_cust_trx_type_id
3536: --FROM ra_cust_trx_types_all ctt Commented Code Yogeshwar (MOAC)
3537: FROM ra_cust_trx_types ctt --New Code Yogeshwar (MOAC)
3538: WHERE ctt.cust_trx_type_id = l_inv_cust_trx_type_id
3539: AND NVL(ctt.org_id, -3114) = DECODE(ctt.cust_trx_type_id,
3540: 1, -3113,
3541: 2, -3113,