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 1925: * accounting to fun_dist_lines

1921: /*-----------------------------------------------------
1922: * PROCEDURE recipient_interco_acct
1923: * ----------------------------------------------------
1924: * Insert a default intercompany account for recipient
1925: * accounting to fun_dist_lines
1926: * ---------------------------------------------------*/
1927:
1928: procedure recipient_interco_acct (
1929: itemtype in varchar2,

Line 1966: FROM fun_dist_lines d

1962:
1963: -- Check if recipient distributions already exist
1964: SELECT COUNT(*)
1965: INTO l_dist_exist
1966: FROM fun_dist_lines d
1967: WHERE d.trx_id = l_trx_id
1968: AND d.dist_type_flag = 'L'
1969: AND d.party_type_flag = 'R';
1970:

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

2025: h.RECIPIENT_ID,
2026: dl.amount_dr,
2027: dl.amount_cr
2028: --FUN_TRX_ENTRY_UTIL.GET_DEFAULT_CCID(l_to_le_id, l_from_le_id, 'P') CCID
2029: FROM fun_dist_lines dl, fun_trx_lines l, fun_trx_headers h
2030: WHERE l.trx_id = l_trx_id
2031: AND dl.trx_id = h.trx_id
2032: AND dl.line_id = l.line_id
2033: AND dl.party_type_flag = 'I'

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

2035: LOOP
2036:
2037:
2038:
2039: SELECT FUN_DIST_LINES_S.nextval INTO l_dist_id FROM dual;
2040:
2041: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2042: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.recipient_interco_acct', 'Inserting distribution ' || l_dist_id);
2043: END IF;

Line 2045: INSERT into FUN_DIST_LINES(

2041: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2042: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.recipient_interco_acct', 'Inserting distribution ' || l_dist_id);
2043: END IF;
2044:
2045: INSERT into FUN_DIST_LINES(
2046: DIST_ID,
2047: LINE_ID,
2048: DIST_NUMBER,
2049: PARTY_ID,

Line 2298: FROM fun_dist_lines dist,

2294: head.init_amount_cr,
2295: head.init_amount_dr,
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

Line 2330: description fun_dist_lines.description%TYPE,

2326: amount_cr NUMBER,
2327: amount_dr NUMBER,
2328: dist_ccid NUMBER,
2329: dist_bsv VARCHAR2(30),
2330: description fun_dist_lines.description%TYPE,
2331: init_amount_cr NUMBER,
2332: init_amount_dr NUMBER,
2333: reci_amount_cr NUMBER,
2334: reci_amount_dr NUMBER);

Line 2347: description fun_dist_lines.description%TYPE,

2343: batch_dist_id NUMBER,
2344: amount_cr NUMBER,
2345: amount_dr NUMBER,
2346: ccid NUMBER (15),
2347: description fun_dist_lines.description%TYPE,
2348: auto_generate_flag VARCHAR2(1),
2349: attribute1 VARCHAR2(150),
2350: attribute2 VARCHAR2(150),
2351: attribute3 VARCHAR2(150),

Line 2554: FROM FUN_DIST_LINES DIST,

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

Line 2573: FROM FUN_DIST_LINES DIST,

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

Line 2592: FROM FUN_DIST_LINES DIST,

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

Line 2611: FROM FUN_DIST_LINES DIST,

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

Line 3014: SELECT FUN_DIST_LINES_S.nextval

3010: -- Now build the new distribution record
3011: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3012: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'Build the initiator distribution lines');
3013: END IF;
3014: SELECT FUN_DIST_LINES_S.nextval
3015: INTO l_new_dist_tbl(l_new_index).dist_id
3016: FROM dual;
3017:
3018: l_new_dist_tbl(l_new_index).line_id := l_init_dist_tbl(1).line_id;

Line 3386: SELECT FUN_DIST_LINES_S.nextval

3382: -- Now build the new distribution record
3383: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3384: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'Build the Distribution lines');
3385: END IF;
3386: SELECT FUN_DIST_LINES_S.nextval
3387: INTO l_new_dist_tbl(l_new_index).dist_id
3388: FROM dual;
3389:
3390: l_new_dist_tbl(l_new_index).line_id := l_reci_dist_tbl(1).line_id;

Line 3418: DELETE fun_dist_lines

3414: -- Delete existing intercompany account distribution lines if exists.
3415: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3416: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'If Sucessful Delete existing lines and insert.');
3417: END IF;
3418: DELETE fun_dist_lines
3419: WHERE trx_id = l_trx_id
3420: AND dist_type_flag IN ('R','P');
3421:
3422:

Line 3425: INSERT into FUN_DIST_LINES

3421:
3422:
3423:
3424: FORALL i IN 1..l_new_dist_tbl.COUNT
3425: INSERT into FUN_DIST_LINES
3426: VALUES l_new_dist_tbl(i);
3427:
3428:
3429: END IF;