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.FUN_RECIPIENT_WF dependencies on FUN_TRX_BATCHES

Line 41: FROM fun_trx_batches

37: l_n_trx number;
38: BEGIN
39: -- Lock batch.
40: SELECT batch_id INTO l_n_trx
41: FROM fun_trx_batches
42: WHERE batch_id = p_batch_id
43: FOR UPDATE;
44:
45: SELECT COUNT(h.trx_id) INTO l_n_trx

Line 46: FROM fun_trx_batches b,

42: WHERE batch_id = p_batch_id
43: FOR UPDATE;
44:
45: SELECT COUNT(h.trx_id) INTO l_n_trx
46: FROM fun_trx_batches b,
47: fun_trx_headers h
48: WHERE h.batch_id = b.batch_id AND
49: b.batch_id = p_batch_id;
50:

Line 65: DELETE FROM fun_trx_batches

61: WHERE trx_id = p_trx_id;
62:
63: -- Delete batch if I'm last.
64: IF(l_n_trx = 1) THEN
65: DELETE FROM fun_trx_batches
66: WHERE batch_id = p_batch_id;
67: END IF;
68:
69: END delete_trx_batch;

Line 95: FROM fun_trx_batches

91: l_rec.currency_code, l_rec.exchange_rate_type, l_rec.status,
92: l_rec.description, l_rec.trx_type_id, l_rec.trx_type_code,
93: l_rec.gl_date, l_rec.batch_date, l_rec.reject_allowed,
94: l_rec.from_recurring_batch
95: FROM fun_trx_batches
96: WHERE batch_id = p_batch_id;
97:
98: RETURN l_rec;
99: END make_batch_rec;

Line 241: -- FROM fun_trx_batches

237: itemkey => itemkey,
238: aname => 'TRX_ID');
239:
240: -- SELECT batch_number INTO l_batch_num
241: -- FROM fun_trx_batches
242: -- WHERE batch_id = l_batch_id;
243:
244: /*
245: SELECT

Line 252: FROM fun_trx_batches b, hz_parties h

248: 0, b.running_total_dr,
249: b.running_total_cr),'99999999999999999999999999999999999999999999999.99'))||' '||b.currency_code,
250: h.party_name
251: INTO l_batch_num, l_trx_amt, l_initiator_name
252: FROM fun_trx_batches b, hz_parties h
253: WHERE batch_id = l_batch_id
254: AND b.initiator_id = h.party_id;
255: */
256: -- added to get transaction amount not batch amount

Line 262: from fun_trx_headers h, fun_trx_batches b

258: select b.batch_number,ltrim(to_char(decode(nvl(h.reci_amount_cr,0),
259: 0,h.reci_amount_dr,
260: h.reci_amount_cr),'99999999999999999999999999999999999999999999999.99'))||' '||b.currency_code
261: into l_batch_num, l_trx_amt
262: from fun_trx_headers h, fun_trx_batches b
263: where b.batch_id = l_batch_id
264: and h.trx_id = l_trx_id;
265:
266: -- to get initiator name

Line 281: fun_trx_batches b

277: SELECT p.PARTY_NAME PERSON_NAME
278: INTO l_initiator_person
279: FROM hz_parties p,
280: fnd_user fu,
281: fun_trx_batches b
282: WHERE fu.person_party_id = p.party_id
283: AND fu.user_id = b.last_updated_by
284: AND b.batch_id = l_batch_id;
285:

Line 621: FROM fun_trx_batches b, fun_trx_types_b t

617: itemkey => itemkey,
618: aname => 'TRX_ID');
619:
620: SELECT t.manual_approve_flag INTO l_result
621: FROM fun_trx_batches b, fun_trx_types_b t
622: WHERE b.batch_id = l_batch_id AND
623: b.trx_type_id = t.trx_type_id;
624:
625: IF (l_result = 'Y') THEN

Line 821: FROM fun_trx_batches

817: itemkey => itemkey,
818: aname => 'BATCH_ID');
819:
820: SELECT reject_allow_flag INTO l_result
821: FROM fun_trx_batches
822: WHERE batch_id = l_batch_id;
823:
824: IF (l_result = 'Y') THEN
825: resultout := wf_engine.eng_completed||':T';

Line 1120: FROM fun_trx_batches b,

1116: INTO l_from_le_id, l_gl_date, l_to_le_id, l_to_ledger_id,
1117: l_from_org_id, l_to_org_id, l_trx_date,
1118: l_initiator_id,
1119: l_recipient_id
1120: FROM fun_trx_batches b,
1121: fun_trx_headers h
1122: WHERE b.batch_id = l_batch_id AND
1123: h.trx_id = l_trx_id AND
1124: h.batch_id = b.batch_id;

Line 1176: from fun_trx_headers h, fun_trx_batches b

1172: select ltrim(to_char(decode(nvl(h.reci_amount_cr,0),
1173: 0,h.reci_amount_dr,
1174: h.reci_amount_cr),'999999999.99'))||' '||b.currency_code
1175: into l_trx_amt
1176: from fun_trx_headers h, fun_trx_batches b
1177: where b.batch_id = l_batch_id
1178: and h.trx_id = l_trx_id;
1179:
1180: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 1253: l_exchange_rate_type fun_trx_batches.exchange_rate_type%TYPE;

1249: l_currency varchar2(15);
1250: l_invoice_num varchar2(50);
1251: l_success boolean;
1252: l_status varchar2(15);
1253: l_exchange_rate_type fun_trx_batches.exchange_rate_type%TYPE;
1254: BEGIN
1255: IF (funcmode = 'RUN') THEN
1256: l_vendor_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1257: itemkey => itemkey,

Line 1278: FROM fun_trx_batches

1274: fun_tca_pkg.get_ou_id(initiator_id) from_org_id
1275: INTO l_batch_date, l_gl_date, l_currency,
1276: l_exchange_rate_type,
1277: l_from_org_id
1278: FROM fun_trx_batches
1279: WHERE batch_id = l_batch_id;
1280:
1281: SELECT ar_invoice_number INTO l_invoice_Num
1282: FROM fun_trx_headers

Line 1977: FROM fun_trx_batches

1973: avalue => FND_GLOBAL.USER_ID);
1974:
1975: --check reject allowed
1976: SELECT reject_allow_flag INTO l_result
1977: FROM fun_trx_batches
1978: WHERE batch_id = p_batch_id;
1979:
1980: IF (l_result = 'Y')
1981: THEN

Line 2212: FROM FUN_TRX_BATCHES b, FUN_TRX_HEADERS h

2208:
2209:
2210: SELECT b.from_le_id, h.to_le_id, h.reci_amount_cr, h.reci_amount_dr
2211: INTO l_from_le_id, l_to_le_id, l_reci_amount_cr, l_reci_amount_dr
2212: FROM FUN_TRX_BATCHES b, FUN_TRX_HEADERS h
2213: WHERE b.batch_id = l_batch_id
2214: AND b.batch_id = h.batch_id
2215: AND h.trx_id = l_trx_id;
2216:

Line 2528: fun_trx_batches btch

2524: head.reci_amount_cr,
2525: head.reci_amount_dr
2526: FROM fun_dist_lines dist,
2527: fun_trx_headers head,
2528: fun_trx_batches btch
2529: WHERE dist.trx_id = head.trx_id
2530: AND head.batch_id = btch.batch_id
2531: AND dist.party_type_flag = p_party_type
2532: AND head.trx_id = p_trx_id

Line 2668: FROM fun_trx_batches b,

2664: ,y.attribute_category typ_attribute_category
2665: ,l.chart_of_accounts_id coa_id
2666: ,b.batch_date
2667: ,b.gl_date
2668: FROM fun_trx_batches b,
2669: fun_trx_headers t,
2670: fun_trx_types_vl y,
2671: gl_ledgers l
2672: WHERE b.batch_id = t.batch_id

Line 2792: FUN_TRX_BATCHES BTCH

2788: DIST.CCID,'GL_BALANCING') DIST_BSV,
2789: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2790: FROM FUN_DIST_LINES DIST,
2791: FUN_TRX_HEADERS HEAD,
2792: FUN_TRX_BATCHES BTCH
2793: WHERE DIST.TRX_ID = HEAD.TRX_ID
2794: AND HEAD.BATCH_ID = BTCH.BATCH_ID
2795: AND HEAD.TRX_ID = p_trx_id
2796: GROUP BY FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,

Line 2811: FUN_TRX_BATCHES BTCH

2807: DIST.CCID,'GL_BALANCING') DIST_BSV,
2808: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2809: FROM FUN_DIST_LINES DIST,
2810: FUN_TRX_HEADERS HEAD,
2811: FUN_TRX_BATCHES BTCH
2812: WHERE DIST.TRX_ID = HEAD.TRX_ID
2813: AND HEAD.BATCH_ID = BTCH.BATCH_ID
2814: AND HEAD.TRX_ID = p_trx_id
2815: GROUP BY FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,

Line 2830: FUN_TRX_BATCHES BTCH

2826: DIST.CCID,'GL_BALANCING') DIST_BSV,
2827: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2828: FROM FUN_DIST_LINES DIST,
2829: FUN_TRX_HEADERS HEAD,
2830: FUN_TRX_BATCHES BTCH
2831: WHERE DIST.TRX_ID = HEAD.TRX_ID
2832: AND HEAD.BATCH_ID = BTCH.BATCH_ID
2833: AND HEAD.TRX_ID = p_trx_id
2834: GROUP BY FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,

Line 2849: FUN_TRX_BATCHES BTCH

2845: DIST.CCID,'GL_BALANCING') DIST_BSV,
2846: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2847: FROM FUN_DIST_LINES DIST,
2848: FUN_TRX_HEADERS HEAD,
2849: FUN_TRX_BATCHES BTCH
2850: WHERE DIST.TRX_ID = HEAD.TRX_ID
2851: AND HEAD.BATCH_ID = BTCH.BATCH_ID
2852: AND HEAD.TRX_ID = p_trx_id
2853: GROUP BY FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,

Line 3907: FROM fun_trx_batches b,

3903: ,y.attribute_category typ_attribute_category
3904: ,l.chart_of_accounts_id coa_id
3905: ,b.batch_date
3906: ,b.gl_date
3907: FROM fun_trx_batches b,
3908: fun_trx_headers t,
3909: fun_trx_types_vl y,
3910: gl_ledgers l
3911: WHERE b.batch_id = t.batch_id