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_BAL_PKG dependencies on FUN_INTER_ACCOUNTS

Line 1800: FROM fun_inter_accounts accts

1796: -- For 1:1, search from rule 1 and progress through to rule 5 if not found
1797: UPDATE fun_bal_inter_int_gt inter_int
1798: SET rec_acct =
1799: (SELECT ccid
1800: FROM fun_inter_accounts accts
1801: WHERE inter_int.ledger_id = accts.ledger_id
1802: AND DECODE(inter_int.intercompany_mode,
1803: 1, DECODE(le_id, driving_cr_le_id,
1804: DECODE(inter_int.type, 'C', driving_cr_le_id, NULL),

Line 1843: FROM fun_inter_accounts accts

1839: -- For 1:M, search for rule 2
1840: UPDATE fun_bal_inter_int_gt inter_int
1841: SET rec_acct =
1842: (SELECT ccid
1843: FROM fun_inter_accounts accts
1844: WHERE inter_int.ledger_id = accts.ledger_id
1845: AND DECODE(inter_int.intercompany_mode,
1846: 1, DECODE(le_id, driving_cr_le_id,
1847: DECODE(inter_int.type, 'C', driving_cr_le_id, NULL),

Line 1879: FROM fun_inter_accounts accts

1875: -- For M:1, search from rule 3 and progress through to rule 5 if not found
1876: UPDATE fun_bal_inter_int_gt inter_int
1877: SET rec_acct =
1878: (SELECT ccid
1879: FROM fun_inter_accounts accts
1880: WHERE inter_int.ledger_id = accts.ledger_id
1881: AND DECODE(inter_int.intercompany_mode,
1882: 1, DECODE(le_id, driving_cr_le_id,
1883: DECODE(inter_int.type, 'C', driving_cr_le_id, NULL),

Line 1917: FROM fun_inter_accounts accts

1913: -- ie it looks at specific LE without checking for the BSV
1914: UPDATE fun_bal_inter_int_gt inter_int
1915: SET rec_acct =
1916: (SELECT ccid
1917: FROM fun_inter_accounts accts
1918: WHERE inter_int.ledger_id = accts.ledger_id
1919: AND DECODE(inter_int.intercompany_mode,
1920: 1, DECODE(le_id, driving_cr_le_id,
1921: DECODE(inter_int.type, 'C', driving_cr_le_id, NULL),

Line 1948: From fun_inter_accounts Accts

1944: -- This will handle rule 5
1945: --Bug: 9183927
1946: Update Fun_bal_inter_int_gt Inter_int
1947: Set Rec_acct = (Select Ccid
1948: From fun_inter_accounts Accts
1949: Where Inter_int.Ledger_id = Accts.Ledger_id
1950: And Inter_int.Rec_acct Is Null
1951: And Decode(Inter_int.Intercompany_mode, 1,
1952: Decode(Le_id, Driving_cr_le_id,

Line 1976: From fun_inter_accounts Accts

1972:
1973:
1974: Update Fun_bal_inter_int_gt Inter_int
1975: Set Rec_acct = (Select Ccid
1976: From fun_inter_accounts Accts
1977: Where Inter_int.Ledger_id = Accts.Ledger_id
1978: And Inter_int.Rec_acct Is Null
1979: And Decode(Inter_int.Intercompany_mode, 1,
1980: Decode(Le_id, Driving_cr_le_id,

Line 2073: FROM fun_inter_accounts accts

2069: -- 1:1 mapping to begin with
2070: UPDATE fun_bal_inter_int_gt inter_int
2071: SET pay_acct =
2072: (SELECT ccid
2073: FROM fun_inter_accounts accts
2074: WHERE inter_int.ledger_id = accts.ledger_id
2075: AND DECODE(inter_int.intercompany_mode,
2076: 1, DECODE(le_id, driving_dr_le_id,
2077: DECODE(inter_int.type, 'D', driving_dr_le_id, NULL),

Line 2115: FROM fun_inter_accounts accts

2111: -- 1:M - next
2112: UPDATE fun_bal_inter_int_gt inter_int
2113: SET pay_acct =
2114: (SELECT ccid
2115: FROM fun_inter_accounts accts
2116: WHERE inter_int.ledger_id = accts.ledger_id
2117: AND DECODE(inter_int.intercompany_mode,
2118: 1, DECODE(le_id, driving_dr_le_id,
2119: DECODE(inter_int.type, 'D', driving_dr_le_id, NULL),

Line 2150: FROM fun_inter_accounts accts

2146: -- M:1 - next
2147: UPDATE fun_bal_inter_int_gt inter_int
2148: SET pay_acct =
2149: (SELECT ccid
2150: FROM fun_inter_accounts accts
2151: WHERE inter_int.ledger_id = accts.ledger_id
2152: AND DECODE(inter_int.intercompany_mode,
2153: 1, DECODE(le_id, driving_dr_le_id,
2154: DECODE(inter_int.type, 'D', driving_dr_le_id, NULL),

Line 2186: FROM fun_inter_accounts accts

2182: -- ie from le to te
2183: UPDATE fun_bal_inter_int_gt inter_int
2184: SET pay_acct =
2185: (SELECT ccid
2186: FROM fun_inter_accounts accts
2187: WHERE inter_int.ledger_id = accts.ledger_id
2188: AND DECODE(inter_int.intercompany_mode,
2189: 1, DECODE(le_id, driving_dr_le_id,
2190: DECODE(inter_int.type, 'D', driving_dr_le_id, NULL),

Line 2218: FROM fun_inter_accounts accts

2214: --Bug: 9183927
2215: UPDATE fun_bal_inter_int_gt inter_int
2216: SET pay_acct =
2217: (SELECT ccid
2218: FROM fun_inter_accounts accts
2219: WHERE inter_int.ledger_id = accts.ledger_id
2220: AND inter_int.pay_acct IS NULL
2221: AND DECODE(inter_int.intercompany_mode,
2222: 1, DECODE(le_id, driving_dr_le_id,

Line 2247: FROM fun_inter_accounts accts

2243:
2244: UPDATE fun_bal_inter_int_gt inter_int
2245: SET pay_acct =
2246: (SELECT ccid
2247: FROM fun_inter_accounts accts
2248: WHERE inter_int.ledger_id = accts.ledger_id
2249: AND inter_int.pay_acct IS NULL
2250: AND DECODE(inter_int.intercompany_mode,
2251: 1, DECODE(le_id, driving_dr_le_id,

Line 2343: FROM fun_inter_accounts accts

2339: UPDATE fun_bal_inter_int_gt inter_int
2340: SET rec_acct = -1
2341: WHERE rec_acct IS NULL AND
2342: EXISTS (SELECT 'Receivables Accounts exist but not defaulted'
2343: FROM fun_inter_accounts accts
2344: WHERE inter_int.ledger_id = accts.ledger_id
2345: AND accts.type = 'R'
2346: AND DECODE(inter_int.intercompany_mode,
2347: 1, DECODE(le_id,

Line 2372: FROM fun_inter_accounts accts

2368: UPDATE fun_bal_inter_int_gt inter_int
2369: SET pay_acct = -1
2370: WHERE pay_acct IS NULL AND
2371: EXISTS (SELECT 'Payables Accounts exist but not defaulted'
2372: FROM fun_inter_accounts accts
2373: WHERE inter_int.ledger_id = accts.ledger_id
2374: AND accts.type = 'P'
2375: AND DECODE(inter_int.intercompany_mode,
2376: 1, DECODE(le_id,

Line 2727: INSERT INTO FUN_INTER_ACCOUNTS_ADDL

2723: -- Retrieve balancing segment value from the receivables and payables accounts
2724: update_inter_seg_val;
2725: /* 8200511 */
2726:
2727: INSERT INTO FUN_INTER_ACCOUNTS_ADDL
2728: (FROM_LE_ID,
2729: LEDGER_ID,
2730: TO_LE_ID,
2731: CCID,

Line 2773: FROM FUN_INTER_ACCOUNTS_V ACCTV

2769: AND BAL_INTER_INT.PAY_BSV IS NOT NULL
2770: AND BAL_INTER_INT.REC_BSV IS NOT NULL
2771: AND NOT EXISTS(
2772: SELECT 'X'
2773: FROM FUN_INTER_ACCOUNTS_V ACCTV
2774: WHERE ACCTV.FROM_LE_ID = DECODE(BAL_INTER_INT.INTERCOMPANY_MODE,1,BAL_INTER_INT.DRIVING_CR_LE_ID,
2775: 2,(DECODE(BAL_INTER_INT.TYPE,'C',BAL_INTER_INT.LE_ID,
2776: BAL_INTER_INT.DRIVING_DR_LE_ID)),
2777: 3,(DECODE(BAL_INTER_INT.TYPE,'D',BAL_INTER_INT.DRIVING_CR_LE_ID,

Line 2795: INSERT INTO FUN_INTER_ACCOUNTS_ADDL

2791: );
2792:
2793:
2794:
2795: INSERT INTO FUN_INTER_ACCOUNTS_ADDL
2796: (FROM_LE_ID,
2797: LEDGER_ID,
2798: TO_LE_ID,
2799: CCID,

Line 2841: FROM FUN_INTER_ACCOUNTS_V ACCTV

2837: AND BAL_INTER_INT.PAY_BSV IS NOT NULL
2838: AND BAL_INTER_INT.REC_BSV IS NOT NULL
2839: AND NOT EXISTS (
2840: SELECT 'X'
2841: FROM FUN_INTER_ACCOUNTS_V ACCTV
2842: WHERE ACCTV.FROM_LE_ID = DECODE(BAL_INTER_INT.INTERCOMPANY_MODE,1,BAL_INTER_INT.DRIVING_DR_LE_ID,
2843: 2,(DECODE(BAL_INTER_INT.TYPE,'C',BAL_INTER_INT.DRIVING_DR_LE_ID,
2844: BAL_INTER_INT.LE_ID)),
2845: 3,(DECODE(BAL_INTER_INT.TYPE,'D',BAL_INTER_INT.LE_ID,