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_BAL_INTER_INT2_GT

Line 1007: -- Insert into FUN_BAL_INTER_INT2_GT with all lines that require Intercompany balancing

1003: AND (headers.driving_dr_le_id IS NULL
1004: OR
1005: headers.driving_cr_le_id IS NULL));
1006:
1007: -- Insert into FUN_BAL_INTER_INT2_GT with all lines that require Intercompany balancing
1008: -- Changed the query for bug 9433610
1009: --Bug: 11657458
1010: INSERT INTO FUN_BAL_INTER_INT2_GT
1011: (GROUP_ID,

Line 1010: INSERT INTO FUN_BAL_INTER_INT2_GT

1006:
1007: -- Insert into FUN_BAL_INTER_INT2_GT with all lines that require Intercompany balancing
1008: -- Changed the query for bug 9433610
1009: --Bug: 11657458
1010: INSERT INTO FUN_BAL_INTER_INT2_GT
1011: (GROUP_ID,
1012: LEDGER_ID,
1013: GL_DATE,
1014: STATUS,

Line 1145: FROM fun_bal_inter_int2_gt lines

1141:
1142: null DR_LE_BSV,
1143: null CR_LE_BSV,
1144: LINE_LE_BSV
1145: FROM fun_bal_inter_int2_gt lines
1146: GROUP BY
1147: GROUP_ID,
1148: LEDGER_ID,
1149: LE_ID,

Line 1181: update fun_bal_inter_int2_gt t2

1177: WHERE upd.group_id = cmp1.group_id
1178: AND cmp1.type='C'
1179: ),'Many'));
1180:
1181: update fun_bal_inter_int2_gt t2
1182: set driving_dr_le_bsv = (select driving_dr_le_bsv
1183: from fun_bal_inter_int3_gt dr_t3
1184: where dr_t3.group_id = t2.group_id
1185: and dr_t3.le_id = t2.le_id

Line 1189: update fun_bal_inter_int2_gt t2

1185: and dr_t3.le_id = t2.le_id
1186: and dr_t3.line_le_bsv = t2.line_le_bsv
1187: );
1188:
1189: update fun_bal_inter_int2_gt t2
1190: set driving_cr_le_bsv = (select driving_cr_le_bsv
1191: from fun_bal_inter_int3_gt dr_t3
1192: where dr_t3.group_id = t2.group_id
1193: and dr_t3.le_id = t2.le_id

Line 1198: Update fun_bal_inter_int2_gt

1194: and dr_t3.line_le_bsv = t2.line_le_bsv
1195: );
1196:
1197: --updating the driving_dr_le_bsv ,driving_cr_le_bsv for the Many to many case #9392684
1198: Update fun_bal_inter_int2_gt
1199: SET (driving_dr_le_bsv, driving_cr_le_bsv)=(Select 'Many','Many' from Dual)
1200: where group_id IN (Select upd1.group_id from (select count(DISTINCT inter_int2.line_le_bsv) count1, group_id from fun_bal_inter_int2_gt inter_int2
1201: where type='D'
1202: GROUP by group_id) upd1,

Line 1200: where group_id IN (Select upd1.group_id from (select count(DISTINCT inter_int2.line_le_bsv) count1, group_id from fun_bal_inter_int2_gt inter_int2

1196:
1197: --updating the driving_dr_le_bsv ,driving_cr_le_bsv for the Many to many case #9392684
1198: Update fun_bal_inter_int2_gt
1199: SET (driving_dr_le_bsv, driving_cr_le_bsv)=(Select 'Many','Many' from Dual)
1200: where group_id IN (Select upd1.group_id from (select count(DISTINCT inter_int2.line_le_bsv) count1, group_id from fun_bal_inter_int2_gt inter_int2
1201: where type='D'
1202: GROUP by group_id) upd1,
1203: (select count(DISTINCT inter_int2.line_le_bsv) count1, group_id from fun_bal_inter_int2_gt inter_int2
1204: WHERE type='C'

Line 1203: (select count(DISTINCT inter_int2.line_le_bsv) count1, group_id from fun_bal_inter_int2_gt inter_int2

1199: SET (driving_dr_le_bsv, driving_cr_le_bsv)=(Select 'Many','Many' from Dual)
1200: where group_id IN (Select upd1.group_id from (select count(DISTINCT inter_int2.line_le_bsv) count1, group_id from fun_bal_inter_int2_gt inter_int2
1201: where type='D'
1202: GROUP by group_id) upd1,
1203: (select count(DISTINCT inter_int2.line_le_bsv) count1, group_id from fun_bal_inter_int2_gt inter_int2
1204: WHERE type='C'
1205: GROUP by group_id) upd2
1206: WHERE upd1.group_id=upd2.group_id
1207: AND upd1.count1 > 1

Line 1212: UPDATE fun_bal_inter_int2_gt upd1

1208: AND upd2.count1 > 1) ;
1209:
1210: --change in Driving Debit and driving credit leid
1211:
1212: UPDATE fun_bal_inter_int2_gt upd1
1213: SET driving_dr_le_id = DECODE(upd1.TYPE, 'D', upd1.LE_ID, DECODE((select count(DISTINCT upd2.le_id ) from fun_bal_inter_int2_gt UPD2
1214: WHERE type = 'D' AND upd2.group_id=upd1.group_id), 1, (SELECT DISTINCT LE_ID FROM fun_bal_inter_int2_gt upd3 WHERE TYPE = 'D' AND upd3.group_id= upd1.group_id), -1))
1215: WHERE intercompany_mode IN (1,2,3)
1216: AND ( driving_dr_le_bsv <>'Many'

Line 1213: SET driving_dr_le_id = DECODE(upd1.TYPE, 'D', upd1.LE_ID, DECODE((select count(DISTINCT upd2.le_id ) from fun_bal_inter_int2_gt UPD2

1209:
1210: --change in Driving Debit and driving credit leid
1211:
1212: UPDATE fun_bal_inter_int2_gt upd1
1213: SET driving_dr_le_id = DECODE(upd1.TYPE, 'D', upd1.LE_ID, DECODE((select count(DISTINCT upd2.le_id ) from fun_bal_inter_int2_gt UPD2
1214: WHERE type = 'D' AND upd2.group_id=upd1.group_id), 1, (SELECT DISTINCT LE_ID FROM fun_bal_inter_int2_gt upd3 WHERE TYPE = 'D' AND upd3.group_id= upd1.group_id), -1))
1215: WHERE intercompany_mode IN (1,2,3)
1216: AND ( driving_dr_le_bsv <>'Many'
1217: OR driving_cr_le_bsv <>'Many');

Line 1214: WHERE type = 'D' AND upd2.group_id=upd1.group_id), 1, (SELECT DISTINCT LE_ID FROM fun_bal_inter_int2_gt upd3 WHERE TYPE = 'D' AND upd3.group_id= upd1.group_id), -1))

1210: --change in Driving Debit and driving credit leid
1211:
1212: UPDATE fun_bal_inter_int2_gt upd1
1213: SET driving_dr_le_id = DECODE(upd1.TYPE, 'D', upd1.LE_ID, DECODE((select count(DISTINCT upd2.le_id ) from fun_bal_inter_int2_gt UPD2
1214: WHERE type = 'D' AND upd2.group_id=upd1.group_id), 1, (SELECT DISTINCT LE_ID FROM fun_bal_inter_int2_gt upd3 WHERE TYPE = 'D' AND upd3.group_id= upd1.group_id), -1))
1215: WHERE intercompany_mode IN (1,2,3)
1216: AND ( driving_dr_le_bsv <>'Many'
1217: OR driving_cr_le_bsv <>'Many');
1218:

Line 1220: UPDATE fun_bal_inter_int2_gt upd1

1216: AND ( driving_dr_le_bsv <>'Many'
1217: OR driving_cr_le_bsv <>'Many');
1218:
1219:
1220: UPDATE fun_bal_inter_int2_gt upd1
1221: SET driving_cr_le_id = DECODE(upd1.TYPE, 'C', upd1.LE_ID, DECODE((select count(DISTINCT upd2.le_id) from fun_bal_inter_int2_gt UPD2
1222: WHERE type = 'C' AND upd2.group_id=upd1.group_id), 1, (SELECT DISTINCT LE_ID FROM fun_bal_inter_int2_gt upd3 WHERE TYPE = 'C' AND upd3.group_id= upd1.group_id), -1))
1223: WHERE intercompany_mode IN (1,2,3)
1224: AND ( driving_dr_le_bsv <>'Many'

Line 1221: SET driving_cr_le_id = DECODE(upd1.TYPE, 'C', upd1.LE_ID, DECODE((select count(DISTINCT upd2.le_id) from fun_bal_inter_int2_gt UPD2

1217: OR driving_cr_le_bsv <>'Many');
1218:
1219:
1220: UPDATE fun_bal_inter_int2_gt upd1
1221: SET driving_cr_le_id = DECODE(upd1.TYPE, 'C', upd1.LE_ID, DECODE((select count(DISTINCT upd2.le_id) from fun_bal_inter_int2_gt UPD2
1222: WHERE type = 'C' AND upd2.group_id=upd1.group_id), 1, (SELECT DISTINCT LE_ID FROM fun_bal_inter_int2_gt upd3 WHERE TYPE = 'C' AND upd3.group_id= upd1.group_id), -1))
1223: WHERE intercompany_mode IN (1,2,3)
1224: AND ( driving_dr_le_bsv <>'Many'
1225: OR driving_cr_le_bsv <>'Many');

Line 1222: WHERE type = 'C' AND upd2.group_id=upd1.group_id), 1, (SELECT DISTINCT LE_ID FROM fun_bal_inter_int2_gt upd3 WHERE TYPE = 'C' AND upd3.group_id= upd1.group_id), -1))

1218:
1219:
1220: UPDATE fun_bal_inter_int2_gt upd1
1221: SET driving_cr_le_id = DECODE(upd1.TYPE, 'C', upd1.LE_ID, DECODE((select count(DISTINCT upd2.le_id) from fun_bal_inter_int2_gt UPD2
1222: WHERE type = 'C' AND upd2.group_id=upd1.group_id), 1, (SELECT DISTINCT LE_ID FROM fun_bal_inter_int2_gt upd3 WHERE TYPE = 'C' AND upd3.group_id= upd1.group_id), -1))
1223: WHERE intercompany_mode IN (1,2,3)
1224: AND ( driving_dr_le_bsv <>'Many'
1225: OR driving_cr_le_bsv <>'Many');
1226:

Line 1228: UPDATE fun_bal_inter_int2_gt inter_int1 SET status='DEL'

1224: AND ( driving_dr_le_bsv <>'Many'
1225: OR driving_cr_le_bsv <>'Many');
1226:
1227: -- marking the lines to be deletd which need intracompany balancing #9392684
1228: UPDATE fun_bal_inter_int2_gt inter_int1 SET status='DEL'
1229: WHERE (inter_int1.type, inter_int1.le_id,inter_int1.group_id) IN
1230: (SELECT DECODE(SIGN(NVL(cr_sum, 0) - NVL(dr_sum, 0)), 1, 'D', -1, 'C', 'X'),
1231: le_id,
1232: group_id

Line 1238: FROM fun_bal_inter_int2_gt inter_int2

1234: (SELECT SUM(entered_amt_cr) cr_sum,
1235: SUM(entered_amt_dr) dr_sum,
1236: le_id,
1237: group_id
1238: FROM fun_bal_inter_int2_gt inter_int2
1239: WHERE (inter_int2.le_id,inter_int2.group_id) IN
1240: (SELECT inter_int3.le_id,
1241: inter_int3.group_id
1242: FROM fun_bal_inter_int2_gt inter_int3

Line 1242: FROM fun_bal_inter_int2_gt inter_int3

1238: FROM fun_bal_inter_int2_gt inter_int2
1239: WHERE (inter_int2.le_id,inter_int2.group_id) IN
1240: (SELECT inter_int3.le_id,
1241: inter_int3.group_id
1242: FROM fun_bal_inter_int2_gt inter_int3
1243: WHERE inter_int3.intercompany_mode IN (1,2,3)
1244: AND ( inter_int3.driving_dr_le_bsv <>'Many'
1245: OR inter_int3.driving_cr_le_bsv <>'Many')
1246: HAVING COUNT(*) > 1

Line 1258: UPDATE fun_bal_inter_int2_gt inter_int2

1254: )
1255: ) ;
1256: -- Bug: 12354478
1257:
1258: UPDATE fun_bal_inter_int2_gt inter_int2
1259: SET inter_int2.status='DEL'
1260: where
1261: not exists (select 1 from fun_bal_inter_int2_gt inter_int3
1262: where inter_int2.group_id = inter_int3.group_id

Line 1261: not exists (select 1 from fun_bal_inter_int2_gt inter_int3

1257:
1258: UPDATE fun_bal_inter_int2_gt inter_int2
1259: SET inter_int2.status='DEL'
1260: where
1261: not exists (select 1 from fun_bal_inter_int2_gt inter_int3
1262: where inter_int2.group_id = inter_int3.group_id
1263: and inter_int2.le_id <> inter_int3.le_id
1264: and inter_int2.type <> inter_int3.type)
1265: AND inter_int2.intercompany_mode IN (1,2,3)

Line 1270: /*UPDATE fun_bal_inter_int2_gt inter_int1 SET status='DEL'

1266: AND ( inter_int2.driving_dr_le_bsv <>'Many'
1267: OR inter_int2.driving_cr_le_bsv <>'Many');
1268: -- End Bug: 12354478
1269:
1270: /*UPDATE fun_bal_inter_int2_gt inter_int1 SET status='DEL'
1271: WHERE (inter_int1.type, inter_int1.le_id,inter_int1.group_id) IN
1272: (SELECT DECODE(SIGN(NVL(cr_sum, 0) - NVL(dr_sum, 0)), 1, 'D', -1, 'C', 'X'),
1273: le_id,
1274: group_id

Line 1280: FROM fun_bal_inter_int2_gt inter_int2

1276: (SELECT SUM(entered_amt_cr) cr_sum,
1277: SUM(entered_amt_dr) dr_sum,
1278: le_id,
1279: group_id
1280: FROM fun_bal_inter_int2_gt inter_int2
1281: WHERE (inter_int2.le_id,inter_int2.group_id) IN
1282: (SELECT le_id,
1283: group_id
1284: FROM fun_bal_inter_int2_gt

Line 1284: FROM fun_bal_inter_int2_gt

1280: FROM fun_bal_inter_int2_gt inter_int2
1281: WHERE (inter_int2.le_id,inter_int2.group_id) IN
1282: (SELECT le_id,
1283: group_id
1284: FROM fun_bal_inter_int2_gt
1285: WHERE intercompany_mode IN (1,2,3)
1286: AND ((driving_cr_le_bsv ='Many'
1287: AND driving_dr_le_bsv <>'Many')
1288: OR (driving_dr_le_bsv ='Many'

Line 1300: UPDATE fun_bal_inter_int2_gt inter_int1

1296: )
1297: ) ;*/
1298:
1299: --updating the entered dr and cr values of the lines that do not need to be deleted.#9392684
1300: UPDATE fun_bal_inter_int2_gt inter_int1
1301: SET
1302: (
1303: inter_int1.entered_amt_cr
1304: )

Line 1307: FROM fun_bal_inter_int2_gt inter_int2

1303: inter_int1.entered_amt_cr
1304: )
1305: =
1306: (SELECT NVL(inter_int1.entered_amt_cr,0) - NVL(SUM(NVL(inter_int2.entered_amt_dr,0)),0)
1307: FROM fun_bal_inter_int2_gt inter_int2
1308: WHERE inter_int2.type='D'
1309: AND inter_int2.le_id= inter_int1.le_id
1310: AND inter_int2.group_id = inter_int1.group_id
1311: group by inter_int2.group_id)

Line 1313: AND 'D'=(Select DISTINCT type from fun_bal_inter_int2_gt inter_int3

1309: AND inter_int2.le_id= inter_int1.le_id
1310: AND inter_int2.group_id = inter_int1.group_id
1311: group by inter_int2.group_id)
1312: WHERE inter_int1.type='C'
1313: AND 'D'=(Select DISTINCT type from fun_bal_inter_int2_gt inter_int3
1314: WHERE inter_int3.group_id= inter_int1.group_id
1315: AND inter_int3.le_id= inter_int1.le_id
1316: AND inter_int3.status='DEL');
1317:

Line 1319: UPDATE fun_bal_inter_int2_gt inter_int1

1315: AND inter_int3.le_id= inter_int1.le_id
1316: AND inter_int3.status='DEL');
1317:
1318: --9692257
1319: UPDATE fun_bal_inter_int2_gt inter_int1
1320: SET
1321: (
1322: inter_int1.accounted_amt_cr
1323: )

Line 1326: FROM fun_bal_inter_int2_gt inter_int2

1322: inter_int1.accounted_amt_cr
1323: )
1324: =
1325: (SELECT NVL(inter_int1.accounted_amt_cr,0) - NVL(SUM(NVL(inter_int2.accounted_amt_dr,0)),0)
1326: FROM fun_bal_inter_int2_gt inter_int2
1327: WHERE inter_int2.type='D'
1328: AND inter_int2.le_id= inter_int1.le_id
1329: AND inter_int2.group_id = inter_int1.group_id
1330: )

Line 1332: AND 'D'=(Select DISTINCT type from fun_bal_inter_int2_gt inter_int3

1328: AND inter_int2.le_id= inter_int1.le_id
1329: AND inter_int2.group_id = inter_int1.group_id
1330: )
1331: WHERE inter_int1.type='C'
1332: AND 'D'=(Select DISTINCT type from fun_bal_inter_int2_gt inter_int3
1333: WHERE inter_int3.group_id= inter_int1.group_id
1334: AND inter_int3.le_id= inter_int1.le_id
1335: AND inter_int3.status='DEL');
1336:

Line 1340: UPDATE fun_bal_inter_int2_gt inter_int1

1336:
1337:
1338: -- End 9692257
1339:
1340: UPDATE fun_bal_inter_int2_gt inter_int1
1341: SET
1342: (
1343: inter_int1.entered_amt_dr
1344: )

Line 1347: FROM fun_bal_inter_int2_gt inter_int2

1343: inter_int1.entered_amt_dr
1344: )
1345: =
1346: (SELECT NVL(inter_int1.entered_amt_dr,0) - NVL(SUM(NVL(inter_int2.entered_amt_cr,0)),0)
1347: FROM fun_bal_inter_int2_gt inter_int2
1348: WHERE inter_int2.type='C'
1349: AND inter_int2.le_id= inter_int1.le_id
1350: AND inter_int2.group_id = inter_int1.group_id)
1351: WHERE inter_int1.type='D'

Line 1352: AND 'C'=(Select distinct type from fun_bal_inter_int2_gt inter_int3

1348: WHERE inter_int2.type='C'
1349: AND inter_int2.le_id= inter_int1.le_id
1350: AND inter_int2.group_id = inter_int1.group_id)
1351: WHERE inter_int1.type='D'
1352: AND 'C'=(Select distinct type from fun_bal_inter_int2_gt inter_int3
1353: WHERE inter_int3.group_id= inter_int1.group_id
1354: AND inter_int3.le_id= inter_int1.le_id
1355: AND inter_int3.status='DEL');
1356:

Line 1358: UPDATE fun_bal_inter_int2_gt inter_int1

1354: AND inter_int3.le_id= inter_int1.le_id
1355: AND inter_int3.status='DEL');
1356:
1357: -- 9692257
1358: UPDATE fun_bal_inter_int2_gt inter_int1
1359: SET
1360: (
1361: inter_int1.accounted_amt_dr
1362: )

Line 1365: FROM fun_bal_inter_int2_gt inter_int2

1361: inter_int1.accounted_amt_dr
1362: )
1363: =
1364: (SELECT NVL(inter_int1.accounted_amt_dr,0) - NVL(SUM(NVL(inter_int2.accounted_amt_cr,0)),0)
1365: FROM fun_bal_inter_int2_gt inter_int2
1366: WHERE inter_int2.type='C'
1367: AND inter_int2.le_id= inter_int1.le_id
1368: AND inter_int2.group_id = inter_int1.group_id)
1369: WHERE inter_int1.type='D'

Line 1370: AND 'C'=(Select distinct type from fun_bal_inter_int2_gt inter_int3

1366: WHERE inter_int2.type='C'
1367: AND inter_int2.le_id= inter_int1.le_id
1368: AND inter_int2.group_id = inter_int1.group_id)
1369: WHERE inter_int1.type='D'
1370: AND 'C'=(Select distinct type from fun_bal_inter_int2_gt inter_int3
1371: WHERE inter_int3.group_id= inter_int1.group_id
1372: AND inter_int3.le_id= inter_int1.le_id
1373: AND inter_int3.status='DEL');
1374:

Line 1380: DELETE from fun_bal_inter_int2_gt

1376:
1377: --Bug:11823507, 12554299
1378: --Deleting those lines which do not need intercompany balancing #9392684
1379:
1380: DELETE from fun_bal_inter_int2_gt
1381: where status='DEL'
1382: OR (NVL(entered_amt_cr,0)=0
1383: AND NVL(entered_amt_dr,0)=0
1384: AND NVL(accounted_amt_cr,0)=0

Line 1390: WHERE bal_seg_val NOT IN (Select line_le_bsv from fun_bal_inter_int2_gt

1386: );
1387:
1388: --Deleting those BSVs from the fun_bal_le_bsv_map_gt which do not need intercompany balancing #9392684
1389: DELETE from fun_bal_le_bsv_map_gt le_bsv_map
1390: WHERE bal_seg_val NOT IN (Select line_le_bsv from fun_bal_inter_int2_gt
1391: WHERE group_id= le_bsv_map.group_id
1392: AND le_id= le_bsv_map.le_id
1393: ) ;
1394:

Line 1397: UPDATE fun_bal_inter_int2_gt upd

1393: ) ;
1394:
1395: /*
1396: --updating the driving_dr_le_id, driving_dr_le_bsv and pay_bsv for the 1:M and M:1 case #9392684
1397: UPDATE fun_bal_inter_int2_gt upd
1398: SET (driving_dr_le_id, driving_dr_le_bsv,pay_bsv) =
1399: (SELECT DISTINCT le_bsv_map.le_id,le_bsv_map.bal_seg_val,le_bsv_map.bal_seg_val
1400: FROM fun_bal_le_bsv_map_gt le_bsv_map
1401: WHERE le_bsv_map.group_id= upd.group_id

Line 1411: UPDATE fun_bal_inter_int2_gt upd

1407: AND upd.driving_cr_le_bsv<>upd.line_le_bsv
1408: AND status = 'OK'
1409: AND upd.type='D';
1410: --updating the driving_cr_le_id, driving_cr_le_bsv and rec_bsv for the 1:M and M:1 case #9392684
1411: UPDATE fun_bal_inter_int2_gt upd
1412: SET (driving_cr_le_id, driving_cr_le_bsv,rec_bsv) =
1413: (SELECT DISTINCT le_bsv_map.le_id,le_bsv_map.bal_seg_val,le_bsv_map.bal_seg_val
1414: FROM fun_bal_le_bsv_map_gt le_bsv_map
1415: WHERE le_bsv_map.group_id= upd.group_id

Line 1427: UPDATE fun_bal_inter_int2_gt upd1

1423: AND upd.type='C';
1424:
1425:
1426: --change in bsv level mode:
1427: UPDATE fun_bal_inter_int2_gt upd1
1428: SET driving_dr_le_bsv= DECODE(upd1.driving_dr_le_id,-1,'Many',
1429: le_id, line_le_bsv,
1430: (select bal_seg_val
1431: from fun_bal_le_bsv_map_gt

Line 1472: FROM fun_bal_inter_int2_gt lines

1468:
1469: null DR_LE_BSV,
1470: null CR_LE_BSV,
1471: LINE_LE_BSV
1472: FROM fun_bal_inter_int2_gt lines
1473: GROUP BY
1474: GROUP_ID,
1475: LEDGER_ID,
1476: LE_ID,

Line 1508: update fun_bal_inter_int2_gt t2

1504: WHERE upd.group_id = cmp1.group_id
1505: AND cmp1.type='C'
1506: ),'Many'));
1507:
1508: update fun_bal_inter_int2_gt t2
1509: set driving_dr_le_bsv = (select driving_dr_le_bsv
1510: from fun_bal_inter_int3_gt dr_t3
1511: where dr_t3.group_id = t2.group_id
1512: and dr_t3.le_id = t2.le_id

Line 1516: update fun_bal_inter_int2_gt t2

1512: and dr_t3.le_id = t2.le_id
1513: and dr_t3.line_le_bsv = t2.line_le_bsv
1514: );
1515:
1516: update fun_bal_inter_int2_gt t2
1517: set driving_cr_le_bsv = (select driving_cr_le_bsv
1518: from fun_bal_inter_int3_gt dr_t3
1519: where dr_t3.group_id = t2.group_id
1520: and dr_t3.le_id = t2.le_id

Line 1526: Update fun_bal_inter_int2_gt

1522: );
1523:
1524:
1525: --updating the driving_dr_le_bsv ,driving_cr_le_bsv for the Many to many case #9392684
1526: Update fun_bal_inter_int2_gt
1527: SET (driving_dr_le_bsv, driving_cr_le_bsv)=(Select 'Many','Many' from Dual)
1528: where group_id IN (Select upd1.group_id from (select count(DISTINCT inter_int2.line_le_bsv) count1, group_id from fun_bal_inter_int2_gt inter_int2
1529: where type='D'
1530: GROUP by group_id) upd1,

Line 1528: where group_id IN (Select upd1.group_id from (select count(DISTINCT inter_int2.line_le_bsv) count1, group_id from fun_bal_inter_int2_gt inter_int2

1524:
1525: --updating the driving_dr_le_bsv ,driving_cr_le_bsv for the Many to many case #9392684
1526: Update fun_bal_inter_int2_gt
1527: SET (driving_dr_le_bsv, driving_cr_le_bsv)=(Select 'Many','Many' from Dual)
1528: where group_id IN (Select upd1.group_id from (select count(DISTINCT inter_int2.line_le_bsv) count1, group_id from fun_bal_inter_int2_gt inter_int2
1529: where type='D'
1530: GROUP by group_id) upd1,
1531: (select count(DISTINCT inter_int2.line_le_bsv) count1, group_id from fun_bal_inter_int2_gt inter_int2
1532: WHERE type='C'

Line 1531: (select count(DISTINCT inter_int2.line_le_bsv) count1, group_id from fun_bal_inter_int2_gt inter_int2

1527: SET (driving_dr_le_bsv, driving_cr_le_bsv)=(Select 'Many','Many' from Dual)
1528: where group_id IN (Select upd1.group_id from (select count(DISTINCT inter_int2.line_le_bsv) count1, group_id from fun_bal_inter_int2_gt inter_int2
1529: where type='D'
1530: GROUP by group_id) upd1,
1531: (select count(DISTINCT inter_int2.line_le_bsv) count1, group_id from fun_bal_inter_int2_gt inter_int2
1532: WHERE type='C'
1533: GROUP by group_id) upd2
1534: WHERE upd1.group_id=upd2.group_id
1535: AND upd1.count1 > 1

Line 1539: UPDATE fun_bal_inter_int2_gt SET REC_BSV = driving_cr_le_bsv,PAY_BSV = driving_dr_le_bsv

1535: AND upd1.count1 > 1
1536: AND upd2.count1 > 1) ;
1537:
1538: -- updating the pay_bsv and rec_bsv for one-many and many-one cases
1539: UPDATE fun_bal_inter_int2_gt SET REC_BSV = driving_cr_le_bsv,PAY_BSV = driving_dr_le_bsv
1540: WHERE intercompany_mode IN (1,2,3)
1541: AND driving_dr_le_bsv <>'Many'
1542: OR driving_cr_le_bsv <>'Many';
1543:

Line 1545: UPDATE fun_bal_inter_int2_gt t1

1541: AND driving_dr_le_bsv <>'Many'
1542: OR driving_cr_le_bsv <>'Many';
1543:
1544: --Bug: 12354478
1545: UPDATE fun_bal_inter_int2_gt t1
1546: SET driving_dr_le_id = decode(driving_dr_le_bsv, 'Many', -1, (select distinct le_id from FUN_BAL_LE_BSV_MAP_GT le_bsv
1547: where le_bsv.group_id = t1.group_id
1548: and le_bsv.bal_seg_val = t1.driving_dr_le_bsv)),
1549: driving_cr_le_id = decode(driving_cr_le_bsv, 'Many', -1, (select distinct le_id from FUN_BAL_LE_BSV_MAP_GT le_bsv1

Line 1556: UPDATE fun_bal_inter_int2_gt

1552: WHERE intercompany_mode IN (1,2,3)
1553: AND driving_dr_le_bsv <>'Many'
1554: AND driving_cr_le_bsv <>'Many';
1555:
1556: UPDATE fun_bal_inter_int2_gt
1557: SET REC_BSV = driving_dr_le_bsv,
1558: PAY_BSV = driving_cr_le_bsv
1559: WHERE intercompany_mode IN (1,2,3)
1560: and driving_dr_le_bsv <> line_le_bsv

Line 1563: UPDATE fun_bal_inter_int2_gt

1559: WHERE intercompany_mode IN (1,2,3)
1560: and driving_dr_le_bsv <> line_le_bsv
1561: and TYPE = 'D';
1562:
1563: UPDATE fun_bal_inter_int2_gt
1564: SET REC_BSV = driving_dr_le_bsv,
1565: PAY_BSV = driving_cr_le_bsv
1566: WHERE intercompany_mode IN (1,2,3)
1567: and driving_cr_le_bsv <> line_le_bsv

Line 1573: (Select * from fun_bal_inter_int2_gt

1569:
1570:
1571: --inserting the lines of 1:1 into fun_bal_inter_int_gt #9392684
1572: INSERT into fun_bal_inter_int_gt
1573: (Select * from fun_bal_inter_int2_gt
1574: where driving_cr_le_bsv<>'Many'
1575: and driving_dr_le_bsv<>'Many') ;
1576: --inserting the lines of M:M into fun_bal_gt by summarizing at LE level #9392684
1577: INSERT

Line 1622: FROM fun_bal_inter_int2_gt upd1

1618: DECODE(SIGN(SUM(NVL(upd1.accounted_amt_cr, 0))-SUM(NVL(upd1.accounted_amt_dr,0))), 1, 'C', -1, 'D', 0,
1619: DECODE(SIGN(((SUM(NVL(upd1.entered_amt_cr,0)) - SUM(NVL(upd1.entered_amt_dr,0)))) - (SUM(NVL(upd1.accounted_amt_dr,0)) - SUM(NVL(upd1.accounted_amt_cr,0)))), 1, 'C', 'D')) type,
1620: 'Many',
1621: 'Many'
1622: FROM fun_bal_inter_int2_gt upd1
1623: WHERE upd1.driving_dr_le_bsv='Many'
1624: AND upd1.driving_cr_le_bsv='Many'
1625: AND upd1.intercompany_mode IN (1,2,3,4)
1626: GROUP BY upd1.group_id,

Line 1759: from fun_bal_inter_int2_gt upd1,

1755: DECODE(upd1.TYPE,'C','D','C'),
1756: upd1.DRIVING_DR_LE_BSV,
1757: upd1.DRIVING_CR_LE_BSV,
1758: upd2.LINE_LE_BSV
1759: from fun_bal_inter_int2_gt upd1,
1760: fun_bal_inter_int2_gt upd2
1761: where upd2.group_id=upd1.group_id
1762: AND upd1.intercompany_mode in (1,2,3)
1763: AND upd2.intercompany_mode in (1,2,3)

Line 1760: fun_bal_inter_int2_gt upd2

1756: upd1.DRIVING_DR_LE_BSV,
1757: upd1.DRIVING_CR_LE_BSV,
1758: upd2.LINE_LE_BSV
1759: from fun_bal_inter_int2_gt upd1,
1760: fun_bal_inter_int2_gt upd2
1761: where upd2.group_id=upd1.group_id
1762: AND upd1.intercompany_mode in (1,2,3)
1763: AND upd2.intercompany_mode in (1,2,3)
1764: AND NVL(upd1.entered_currency_code,'0')= NVL(upd2.entered_currency_code,'0')