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 214: -- FROM fun_trx_batches

210: itemkey => itemkey,
211: aname => 'TRX_ID');
212:
213: -- SELECT batch_number INTO l_batch_num
214: -- FROM fun_trx_batches
215: -- WHERE batch_id = l_batch_id;
216:
217: /*
218: SELECT

Line 225: FROM fun_trx_batches b, hz_parties h

221: 0, b.running_total_dr,
222: b.running_total_cr),'999999999.99'))||' '||b.currency_code,
223: h.party_name
224: INTO l_batch_num, l_trx_amt, l_initiator_name
225: FROM fun_trx_batches b, hz_parties h
226: WHERE batch_id = l_batch_id
227: AND b.initiator_id = h.party_id;
228: */
229: -- added to get transaction amount not batch amount

Line 235: from fun_trx_headers h, fun_trx_batches b

231: select b.batch_number,ltrim(to_char(decode(nvl(h.reci_amount_cr,0),
232: 0,h.reci_amount_dr,
233: h.reci_amount_cr),'999999999.99'))||' '||b.currency_code
234: into l_batch_num, l_trx_amt
235: from fun_trx_headers h, fun_trx_batches b
236: where b.batch_id = l_batch_id
237: and h.trx_id = l_trx_id;
238:
239: -- to get initiator name

Line 579: FROM fun_trx_batches b, fun_trx_types_b t

575: itemkey => itemkey,
576: aname => 'TRX_ID');
577:
578: SELECT t.manual_approve_flag INTO l_result
579: FROM fun_trx_batches b, fun_trx_types_b t
580: WHERE b.batch_id = l_batch_id AND
581: b.trx_type_id = t.trx_type_id;
582:
583: IF (l_result = 'Y') THEN

Line 779: FROM fun_trx_batches

775: itemkey => itemkey,
776: aname => 'BATCH_ID');
777:
778: SELECT reject_allow_flag INTO l_result
779: FROM fun_trx_batches
780: WHERE batch_id = l_batch_id;
781:
782: IF (l_result = 'Y') THEN
783: resultout := wf_engine.eng_completed||':T';

Line 1030: FROM fun_trx_batches b,

1026: INTO l_from_le_id, l_gl_date, l_to_le_id, l_to_ledger_id,
1027: l_from_org_id, l_to_org_id, l_trx_date,
1028: l_initiator_id,
1029: l_recipient_id
1030: FROM fun_trx_batches b,
1031: fun_trx_headers h
1032: WHERE b.batch_id = l_batch_id AND
1033: h.trx_id = l_trx_id AND
1034: h.batch_id = b.batch_id;

Line 1086: from fun_trx_headers h, fun_trx_batches b

1082: select ltrim(to_char(decode(nvl(h.reci_amount_cr,0),
1083: 0,h.reci_amount_dr,
1084: h.reci_amount_cr),'999999999.99'))||' '||b.currency_code
1085: into l_trx_amt
1086: from fun_trx_headers h, fun_trx_batches b
1087: where b.batch_id = l_batch_id
1088: and h.trx_id = l_trx_id;
1089:
1090: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 1163: l_exchange_rate_type fun_trx_batches.exchange_rate_type%TYPE;

1159: l_currency varchar2(15);
1160: l_invoice_num varchar2(50);
1161: l_success boolean;
1162: l_status varchar2(15);
1163: l_exchange_rate_type fun_trx_batches.exchange_rate_type%TYPE;
1164: BEGIN
1165: IF (funcmode = 'RUN') THEN
1166: l_vendor_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1167: itemkey => itemkey,

Line 1188: FROM fun_trx_batches

1184: fun_tca_pkg.get_ou_id(initiator_id) from_org_id
1185: INTO l_batch_date, l_gl_date, l_currency,
1186: l_exchange_rate_type,
1187: l_from_org_id
1188: FROM fun_trx_batches
1189: WHERE batch_id = l_batch_id;
1190:
1191: SELECT ar_invoice_number INTO l_invoice_Num
1192: FROM fun_trx_headers

Line 1852: FROM fun_trx_batches

1848: avalue => FND_GLOBAL.USER_ID);
1849:
1850: --check reject allowed
1851: SELECT reject_allow_flag INTO l_result
1852: FROM fun_trx_batches
1853: WHERE batch_id = p_batch_id;
1854:
1855: IF (l_result = 'Y')
1856: THEN

Line 1988: FROM FUN_TRX_BATCHES b, FUN_TRX_HEADERS h

1984:
1985:
1986: SELECT b.from_le_id, h.to_le_id, h.reci_amount_cr, h.reci_amount_dr
1987: INTO l_from_le_id, l_to_le_id, l_reci_amount_cr, l_reci_amount_dr
1988: FROM FUN_TRX_BATCHES b, FUN_TRX_HEADERS h
1989: WHERE b.batch_id = l_batch_id
1990: AND b.batch_id = h.batch_id
1991: AND h.trx_id = l_trx_id;
1992:

Line 2300: fun_trx_batches btch

2296: head.reci_amount_cr,
2297: head.reci_amount_dr
2298: FROM fun_dist_lines dist,
2299: fun_trx_headers head,
2300: fun_trx_batches btch
2301: WHERE dist.trx_id = head.trx_id
2302: AND head.batch_id = btch.batch_id
2303: AND dist.party_type_flag = p_party_type
2304: AND head.trx_id = p_trx_id

Line 2438: FROM fun_trx_batches b,

2434: ,y.attribute_category typ_attribute_category
2435: ,l.chart_of_accounts_id coa_id
2436: ,b.batch_date
2437: ,b.gl_date
2438: FROM fun_trx_batches b,
2439: fun_trx_headers t,
2440: fun_trx_types_vl y,
2441: gl_ledgers l
2442: WHERE b.batch_id = t.batch_id

Line 2556: FUN_TRX_BATCHES BTCH

2552: DIST.CCID,'GL_BALANCING') DIST_BSV,
2553: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2554: FROM FUN_DIST_LINES DIST,
2555: FUN_TRX_HEADERS HEAD,
2556: FUN_TRX_BATCHES BTCH
2557: WHERE DIST.TRX_ID = HEAD.TRX_ID
2558: AND HEAD.BATCH_ID = BTCH.BATCH_ID
2559: AND HEAD.TRX_ID = p_trx_id
2560: GROUP BY FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,

Line 2575: FUN_TRX_BATCHES BTCH

2571: DIST.CCID,'GL_BALANCING') DIST_BSV,
2572: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2573: FROM FUN_DIST_LINES DIST,
2574: FUN_TRX_HEADERS HEAD,
2575: FUN_TRX_BATCHES BTCH
2576: WHERE DIST.TRX_ID = HEAD.TRX_ID
2577: AND HEAD.BATCH_ID = BTCH.BATCH_ID
2578: AND HEAD.TRX_ID = p_trx_id
2579: GROUP BY FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,

Line 2594: FUN_TRX_BATCHES BTCH

2590: DIST.CCID,'GL_BALANCING') DIST_BSV,
2591: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2592: FROM FUN_DIST_LINES DIST,
2593: FUN_TRX_HEADERS HEAD,
2594: FUN_TRX_BATCHES BTCH
2595: WHERE DIST.TRX_ID = HEAD.TRX_ID
2596: AND HEAD.BATCH_ID = BTCH.BATCH_ID
2597: AND HEAD.TRX_ID = p_trx_id
2598: GROUP BY FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,

Line 2613: FUN_TRX_BATCHES BTCH

2609: DIST.CCID,'GL_BALANCING') DIST_BSV,
2610: DECODE(DIST.PARTY_TYPE_FLAG,'I', BTCH.FROM_LE_ID, HEAD.TO_LE_ID)
2611: FROM FUN_DIST_LINES DIST,
2612: FUN_TRX_HEADERS HEAD,
2613: FUN_TRX_BATCHES BTCH
2614: WHERE DIST.TRX_ID = HEAD.TRX_ID
2615: AND HEAD.BATCH_ID = BTCH.BATCH_ID
2616: AND HEAD.TRX_ID = p_trx_id
2617: GROUP BY FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,

Line 3527: FROM fun_trx_batches b,

3523: ,y.attribute_category typ_attribute_category
3524: ,l.chart_of_accounts_id coa_id
3525: ,b.batch_date
3526: ,b.gl_date
3527: FROM fun_trx_batches b,
3528: fun_trx_headers t,
3529: fun_trx_types_vl y,
3530: gl_ledgers l
3531: WHERE b.batch_id = t.batch_id