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_DIST_LINES

Line 51: DELETE FROM fun_dist_lines

47: fun_trx_headers h
48: WHERE h.batch_id = b.batch_id AND
49: b.batch_id = p_batch_id;
50:
51: DELETE FROM fun_dist_lines
52: WHERE line_id IN
53: ( SELECT line_id
54: FROM fun_trx_lines
55: WHERE trx_id = p_trx_id );

Line 150: FROM fun_dist_lines d, fun_trx_lines l

146: CURSOR c_dist IS
147: SELECT d.dist_id, d.line_id, d.party_id,
148: d.party_type_flag, d.dist_type_flag, d.batch_dist_id,
149: d.amount_cr, d.amount_dr, d.ccid
150: FROM fun_dist_lines d, fun_trx_lines l
151: WHERE party_type_flag = 'R' AND
152: d.line_id = l.line_id AND
153: l.trx_id = p_trx_id;
154: i number := 1;

Line 2149: * accounting to fun_dist_lines

2145: /*-----------------------------------------------------
2146: * PROCEDURE recipient_interco_acct
2147: * ----------------------------------------------------
2148: * Insert a default intercompany account for recipient
2149: * accounting to fun_dist_lines
2150: * ---------------------------------------------------*/
2151:
2152: procedure recipient_interco_acct (
2153: itemtype in varchar2,

Line 2190: FROM fun_dist_lines d

2186:
2187: -- Check if recipient distributions already exist
2188: SELECT COUNT(*)
2189: INTO l_dist_exist
2190: FROM fun_dist_lines d
2191: WHERE d.trx_id = l_trx_id
2192: AND d.dist_type_flag = 'L'
2193: AND d.party_type_flag = 'R';
2194:

Line 2253: FROM fun_dist_lines dl, fun_trx_lines l, fun_trx_headers h

2249: h.RECIPIENT_ID,
2250: dl.amount_dr,
2251: dl.amount_cr
2252: --FUN_TRX_ENTRY_UTIL.GET_DEFAULT_CCID(l_to_le_id, l_from_le_id, 'P') CCID
2253: FROM fun_dist_lines dl, fun_trx_lines l, fun_trx_headers h
2254: WHERE l.trx_id = l_trx_id
2255: AND dl.trx_id = h.trx_id
2256: AND dl.line_id = l.line_id
2257: AND dl.party_type_flag = 'I'

Line 2263: SELECT FUN_DIST_LINES_S.nextval INTO l_dist_id FROM dual;

2259: LOOP
2260:
2261:
2262:
2263: SELECT FUN_DIST_LINES_S.nextval INTO l_dist_id FROM dual;
2264:
2265: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2266: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.recipient_interco_acct', 'Inserting distribution ' || l_dist_id);
2267: END IF;

Line 2269: INSERT into FUN_DIST_LINES(

2265: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2266: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.recipient_interco_acct', 'Inserting distribution ' || l_dist_id);
2267: END IF;
2268:
2269: INSERT into FUN_DIST_LINES(
2270: DIST_ID,
2271: LINE_ID,
2272: DIST_NUMBER,
2273: PARTY_ID,

Line 2526: FROM fun_dist_lines dist,

2522: head.init_amount_cr,
2523: head.init_amount_dr,
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

Line 2558: description fun_dist_lines.description%TYPE,

2554: amount_cr NUMBER,
2555: amount_dr NUMBER,
2556: dist_ccid NUMBER,
2557: dist_bsv VARCHAR2(30),
2558: description fun_dist_lines.description%TYPE,
2559: init_amount_cr NUMBER,
2560: init_amount_dr NUMBER,
2561: reci_amount_cr NUMBER,
2562: reci_amount_dr NUMBER);

Line 2576: description fun_dist_lines.description%TYPE,

2572: batch_dist_id NUMBER,
2573: amount_cr NUMBER,
2574: amount_dr NUMBER,
2575: ccid NUMBER (15),
2576: description fun_dist_lines.description%TYPE,
2577: auto_generate_flag VARCHAR2(1),
2578: attribute1 VARCHAR2(150),
2579: attribute2 VARCHAR2(150),
2580: attribute3 VARCHAR2(150),

Line 2790: FROM FUN_DIST_LINES DIST,

2786: FROM (SELECT FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,
2787: HEAD.TO_LEDGER_ID),
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

Line 2809: FROM FUN_DIST_LINES DIST,

2805: FROM (SELECT FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,
2806: HEAD.TO_LEDGER_ID),
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

Line 2828: FROM FUN_DIST_LINES DIST,

2824: FROM (SELECT FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,
2825: HEAD.TO_LEDGER_ID),
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

Line 2847: FROM FUN_DIST_LINES DIST,

2843: FROM (SELECT FUN_UTIL.GET_ACCOUNT_SEGMENT_VALUE(DECODE(DIST.PARTY_TYPE_FLAG,'I',BTCH.FROM_LEDGER_ID,
2844: HEAD.TO_LEDGER_ID),
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

Line 3325: SELECT FUN_DIST_LINES_S.nextval

3321: -- Now build the new distribution record
3322: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3323: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'Build the initiator distribution lines');
3324: END IF;
3325: SELECT FUN_DIST_LINES_S.nextval
3326: INTO l_new_dist_tbl(l_new_index).dist_id
3327: FROM dual;
3328:
3329: l_new_dist_tbl(l_new_index).line_id := l_init_dist_tbl(1).line_id;

Line 3768: SELECT FUN_DIST_LINES_S.nextval

3764: -- Now build the new distribution record
3765: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3766: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'Build the Distribution lines');
3767: END IF;
3768: SELECT FUN_DIST_LINES_S.nextval
3769: INTO l_new_dist_tbl(l_new_index).dist_id
3770: FROM dual;
3771:
3772: l_new_dist_tbl(l_new_index).line_id := l_reci_dist_tbl(1).line_id;

Line 3800: DELETE fun_dist_lines

3796: -- Delete existing intercompany account distribution lines if exists.
3797: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3798: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'If Sucessful Delete existing lines and insert.');
3799: END IF;
3800: DELETE fun_dist_lines
3801: WHERE trx_id = l_trx_id
3802: AND dist_type_flag IN ('R','P');
3803:
3804:

Line 3807: INSERT into FUN_DIST_LINES

3803:
3804:
3805:
3806: FORALL i IN 1..l_new_dist_tbl.COUNT
3807: INSERT into FUN_DIST_LINES
3808: VALUES l_new_dist_tbl(i);
3809:
3810: END IF;
3811:

Line 3942: l_init_ccid fun_dist_lines.ccid%TYPE;

3938: l_amb_context_code fun_trx_acct_definitions.amb_context_code%TYPE;
3939: l_account_definition_code fun_trx_acct_definitions.account_definition_code%TYPE;
3940: l_initiator_bsv gl_ledger_le_bsv_specific_v.segment_value%TYPE;
3941: l_recipient_bsv gl_ledger_le_bsv_specific_v.segment_value%TYPE;
3942: l_init_ccid fun_dist_lines.ccid%TYPE;
3943:
3944: BEGIN
3945: x_status := FND_API.G_RET_STS_SUCCESS;
3946: x_ccid := -1;

Line 3951: from fun_dist_lines

3947: l_init_ccid := -1;
3948:
3949: select CCID
3950: into l_init_ccid
3951: from fun_dist_lines
3952: where trx_id = p_trx_id
3953: and party_type_flag = 'I'
3954: and dist_type_flag = 'L'
3955: and rownum = 1;