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 1047: FROM fun_inter_accounts accts

1043: -- For 1:1, search from rule 1 and progress through to rule 5 if not found
1044: UPDATE fun_bal_inter_int_gt inter_int
1045: SET rec_acct =
1046: (SELECT ccid
1047: FROM fun_inter_accounts accts
1048: WHERE inter_int.ledger_id = accts.ledger_id
1049: AND DECODE(inter_int.intercompany_mode,
1050: 1, DECODE(le_id, driving_cr_le_id,
1051: DECODE(inter_int.type, 'C', driving_cr_le_id, NULL),

Line 1090: FROM fun_inter_accounts accts

1086: -- For 1:M, search for rule 2
1087: UPDATE fun_bal_inter_int_gt inter_int
1088: SET rec_acct =
1089: (SELECT ccid
1090: FROM fun_inter_accounts accts
1091: WHERE inter_int.ledger_id = accts.ledger_id
1092: AND DECODE(inter_int.intercompany_mode,
1093: 1, DECODE(le_id, driving_cr_le_id,
1094: DECODE(inter_int.type, 'C', driving_cr_le_id, NULL),

Line 1126: FROM fun_inter_accounts accts

1122: -- For M:1, search from rule 3 and progress through to rule 5 if not found
1123: UPDATE fun_bal_inter_int_gt inter_int
1124: SET rec_acct =
1125: (SELECT ccid
1126: FROM fun_inter_accounts accts
1127: WHERE inter_int.ledger_id = accts.ledger_id
1128: AND DECODE(inter_int.intercompany_mode,
1129: 1, DECODE(le_id, driving_cr_le_id,
1130: DECODE(inter_int.type, 'C', driving_cr_le_id, NULL),

Line 1164: FROM fun_inter_accounts accts

1160: -- ie it looks at specific LE without checking for the BSV
1161: UPDATE fun_bal_inter_int_gt inter_int
1162: SET rec_acct =
1163: (SELECT ccid
1164: FROM fun_inter_accounts accts
1165: WHERE inter_int.ledger_id = accts.ledger_id
1166: AND DECODE(inter_int.intercompany_mode,
1167: 1, DECODE(le_id, driving_cr_le_id,
1168: DECODE(inter_int.type, 'C', driving_cr_le_id, NULL),

Line 1195: FROM fun_inter_accounts accts

1191: -- This will handle rule 5
1192: UPDATE fun_bal_inter_int_gt inter_int
1193: SET rec_acct =
1194: (SELECT ccid
1195: FROM fun_inter_accounts accts
1196: WHERE inter_int.ledger_id = accts.ledger_id
1197: AND inter_int.rec_acct IS NULL
1198: AND DECODE(inter_int.intercompany_mode,
1199: 1, DECODE(le_id, driving_cr_le_id,

Line 1218: FROM fun_inter_accounts accts

1214: -- 1:1 mapping to begin with
1215: UPDATE fun_bal_inter_int_gt inter_int
1216: SET pay_acct =
1217: (SELECT ccid
1218: FROM fun_inter_accounts accts
1219: WHERE inter_int.ledger_id = accts.ledger_id
1220: AND DECODE(inter_int.intercompany_mode,
1221: 1, DECODE(le_id, driving_dr_le_id,
1222: DECODE(inter_int.type, 'D', driving_dr_le_id, NULL),

Line 1260: FROM fun_inter_accounts accts

1256: -- 1:M - next
1257: UPDATE fun_bal_inter_int_gt inter_int
1258: SET pay_acct =
1259: (SELECT ccid
1260: FROM fun_inter_accounts accts
1261: WHERE inter_int.ledger_id = accts.ledger_id
1262: AND DECODE(inter_int.intercompany_mode,
1263: 1, DECODE(le_id, driving_dr_le_id,
1264: DECODE(inter_int.type, 'D', driving_dr_le_id, NULL),

Line 1295: FROM fun_inter_accounts accts

1291: -- M:1 - next
1292: UPDATE fun_bal_inter_int_gt inter_int
1293: SET pay_acct =
1294: (SELECT ccid
1295: FROM fun_inter_accounts accts
1296: WHERE inter_int.ledger_id = accts.ledger_id
1297: AND DECODE(inter_int.intercompany_mode,
1298: 1, DECODE(le_id, driving_dr_le_id,
1299: DECODE(inter_int.type, 'D', driving_dr_le_id, NULL),

Line 1331: FROM fun_inter_accounts accts

1327: -- ie from le to te
1328: UPDATE fun_bal_inter_int_gt inter_int
1329: SET pay_acct =
1330: (SELECT ccid
1331: FROM fun_inter_accounts accts
1332: WHERE inter_int.ledger_id = accts.ledger_id
1333: AND DECODE(inter_int.intercompany_mode,
1334: 1, DECODE(le_id, driving_dr_le_id,
1335: DECODE(inter_int.type, 'D', driving_dr_le_id, NULL),

Line 1362: FROM fun_inter_accounts accts

1358: -- This will deal with rule 5, From LE to All Others
1359: UPDATE fun_bal_inter_int_gt inter_int
1360: SET pay_acct =
1361: (SELECT ccid
1362: FROM fun_inter_accounts accts
1363: WHERE inter_int.ledger_id = accts.ledger_id
1364: AND inter_int.pay_acct IS NULL
1365: AND DECODE(inter_int.intercompany_mode,
1366: 1, DECODE(le_id, driving_dr_le_id,

Line 1387: FROM fun_inter_accounts accts

1383: UPDATE fun_bal_inter_int_gt inter_int
1384: SET rec_acct = -1
1385: WHERE rec_acct IS NULL AND
1386: EXISTS (SELECT 'Receivables Accounts exist but not defaulted'
1387: FROM fun_inter_accounts accts
1388: WHERE inter_int.ledger_id = accts.ledger_id
1389: AND accts.type = 'R'
1390: AND DECODE(inter_int.intercompany_mode,
1391: 1, DECODE(le_id,

Line 1416: FROM fun_inter_accounts accts

1412: UPDATE fun_bal_inter_int_gt inter_int
1413: SET pay_acct = -1
1414: WHERE pay_acct IS NULL AND
1415: EXISTS (SELECT 'Payables Accounts exist but not defaulted'
1416: FROM fun_inter_accounts accts
1417: WHERE inter_int.ledger_id = accts.ledger_id
1418: AND accts.type = 'P'
1419: AND DECODE(inter_int.intercompany_mode,
1420: 1, DECODE(le_id,

Line 1767: INSERT INTO FUN_INTER_ACCOUNTS_ADDL

1763: -- Retrieve balancing segment value from the receivables and payables accounts
1764: update_inter_seg_val;
1765: /* 8200511 */
1766:
1767: INSERT INTO FUN_INTER_ACCOUNTS_ADDL
1768: (FROM_LE_ID,
1769: LEDGER_ID,
1770: TO_LE_ID,
1771: CCID,

Line 1813: FROM FUN_INTER_ACCOUNTS_V ACCTV

1809: AND BAL_INTER_INT.PAY_BSV IS NOT NULL
1810: AND BAL_INTER_INT.REC_BSV IS NOT NULL
1811: AND NOT EXISTS(
1812: SELECT 'X'
1813: FROM FUN_INTER_ACCOUNTS_V ACCTV
1814: WHERE ACCTV.FROM_LE_ID = DECODE(BAL_INTER_INT.INTERCOMPANY_MODE,1,BAL_INTER_INT.DRIVING_CR_LE_ID,
1815: 2,(DECODE(BAL_INTER_INT.TYPE,'C',BAL_INTER_INT.LE_ID,
1816: BAL_INTER_INT.DRIVING_DR_LE_ID)),
1817: 3,(DECODE(BAL_INTER_INT.TYPE,'D',BAL_INTER_INT.DRIVING_CR_LE_ID,

Line 1835: INSERT INTO FUN_INTER_ACCOUNTS_ADDL

1831: );
1832:
1833:
1834:
1835: INSERT INTO FUN_INTER_ACCOUNTS_ADDL
1836: (FROM_LE_ID,
1837: LEDGER_ID,
1838: TO_LE_ID,
1839: CCID,

Line 1881: FROM FUN_INTER_ACCOUNTS_V ACCTV

1877: AND BAL_INTER_INT.PAY_BSV IS NOT NULL
1878: AND BAL_INTER_INT.REC_BSV IS NOT NULL
1879: AND NOT EXISTS (
1880: SELECT 'X'
1881: FROM FUN_INTER_ACCOUNTS_V ACCTV
1882: WHERE ACCTV.FROM_LE_ID = DECODE(BAL_INTER_INT.INTERCOMPANY_MODE,1,BAL_INTER_INT.DRIVING_DR_LE_ID,
1883: 2,(DECODE(BAL_INTER_INT.TYPE,'C',BAL_INTER_INT.DRIVING_DR_LE_ID,
1884: BAL_INTER_INT.LE_ID)),
1885: 3,(DECODE(BAL_INTER_INT.TYPE,'D',BAL_INTER_INT.LE_ID,