[Home] [Help]
985: ' dih.book_type_code = '||''''||PARM.p_book_type_code ||''''||' and'||
986: ' gcc.code_combination_id = dih.code_combination_id'||
987: ' and dih.transaction_header_id_in =';
988: v_selectstmnt2 := '(select to_char(MAX(transaction_heaDer_id))'||
989: ' from fa_transaction_headers trh,'||
990: ' fa_distribution_history dih1'||
991: ' where dih1.asset_id= dih.asset_id and'||
992: ' dih1.book_type_code =dih.book_type_code and'||
993: ' dih1.transaction_header_id_in = trh.transaction_header_id and';
1176: AND BO.asset_id = JGRX_FAREG.var.asset_id
1177: AND (TO_CHAR(BO.date_effective, 'DD-MON-YYYY HH:MI:SS'),transaction_header_id_in) =
1178: (SELECT TO_CHAR(MAX(BO1.date_effective), 'DD-MON-YYYY HH:MI:SS'),
1179: max(transaction_header_id_in)
1180: FROM fa_books BO1, fa_transaction_headers TRH
1181: WHERE BO1.book_type_code = BO.book_type_code
1182: AND BO1.asset_id = BO.asset_id
1183: AND TRH.transaction_header_id= BO1.transaction_header_id_in
1184: AND TRH.transaction_date_entered < PARM.p_begin_period_from_date);
1202: AND BO.asset_id = JGRX_FAREG.var.asset_id
1203: AND (TO_CHAR(BO.date_effective, 'DD-MON-YYYY HH:MI:SS'),transaction_header_id_in) =
1204: (SELECT TO_CHAR(MAX(BO1.date_effective), 'DD-MON-YYYY HH:MI:SS'),
1205: max(transaction_header_id_in)
1206: FROM fa_books BO1,FA_TRANSACTION_HEADERS TRH
1207: WHERE BO1.book_type_code = BO.book_type_code
1208: AND BO1.asset_id = BO.asset_id
1209: AND TRH.transaction_header_id= BO1.transaction_header_id_in
1210: AND TRH.transaction_date_entered <= PARM.p_end_period_to_date);
1268:
1269: SELECT SUM(AD.adjustment_amount)
1270: INTO X_partial_addition
1271: FROM fa_books BO,
1272: fa_transaction_headers TH,
1273: fa_adjustments AD
1274: WHERE BO.book_type_code = PARM.p_book_type_code
1275: AND BO.asset_id = JGRX_FAREG.var.asset_id
1276: AND BO.transaction_header_id_in <> NVL(X_transaction_id_initial, 0)
1296: FA_RX_UTIL_PKG.debug('Get manual adjustment upwards');
1297:
1298: SELECT SUM(AD.adjustment_amount)
1299: INTO X_manual_adjustment_plus
1300: FROM fa_transaction_headers TH,
1301: fa_adjustments AD
1302: WHERE AD.transaction_header_id = TH.transaction_header_id
1303: AND AD.book_type_code = TH.book_type_code
1304: AND AD.asset_id = TH.asset_id
1317: FA_RX_UTIL_PKG.debug('Get revaluations upward ');
1318:
1319: SELECT SUM(AD.adjustment_amount)
1320: INTO X_revaluation_plus
1321: FROM fa_transaction_headers TH,
1322: fa_adjustments AD
1323: WHERE AD.transaction_header_id = TH.transaction_header_id
1324: AND AD.book_type_code = TH.book_type_code
1325: AND AD.asset_id = TH.asset_id
1339: FA_RX_UTIL_PKG.debug('Get reinstatements ');
1340:
1341: SELECT SUM(RE.cost_retired)
1342: INTO X_reinstatements
1343: FROM fa_transaction_headers TH,
1344: fa_retirements RE
1345: WHERE RE.transaction_header_id_out = TH.transaction_header_id
1346: AND RE.book_type_code = TH.book_type_code
1347: AND RE.asset_id = TH.asset_id
1389:
1390: SELECT SUM(AD.adjustment_amount)
1391: INTO X_credit_memos
1392: FROM fa_books BO,
1393: fa_transaction_headers TH,
1394: fa_adjustments AD
1395: WHERE BO.book_type_code = PARM.p_book_type_code
1396: AND BO.asset_id = JGRX_FAREG.var.asset_id
1397: AND BO.transaction_header_id_in <> NVL(X_transaction_id_initial, 0)
1417: FA_RX_UTIL_PKG.debug('Get manual adjustment downwards');
1418:
1419: SELECT SUM(AD.adjustment_amount)
1420: INTO X_manual_adjustment_minus
1421: FROM fa_transaction_headers TH,
1422: fa_adjustments AD
1423: WHERE AD.transaction_header_id = TH.transaction_header_id
1424: AND AD.book_type_code = TH.book_type_code
1425: AND AD.asset_id = TH.asset_id
1438: FA_RX_UTIL_PKG.debug('Get revaluations downward ');
1439:
1440: SELECT SUM(AD.adjustment_amount)
1441: INTO X_revaluation_minus
1442: FROM fa_transaction_headers TH,
1443: fa_adjustments AD
1444: WHERE AD.transaction_header_id = TH.transaction_header_id
1445: AND AD.book_type_code = TH.book_type_code
1446: AND AD.asset_id = TH.asset_id
1459: FA_RX_UTIL_PKG.debug('Get retirements ');
1460:
1461: SELECT SUM(RE.cost_retired)
1462: INTO X_retirements
1463: FROM fa_transaction_headers TH,
1464: fa_retirements RE
1465: WHERE RE.transaction_header_id_in = TH.transaction_header_id
1466: AND RE.book_type_code = TH.book_type_code
1467: AND RE.asset_id = TH.asset_id
2152: SELECT TH.transaction_type_code,
2153: TH.transaction_header_id,
2154: BO.date_placed_in_service,
2155: BO.cost
2156: FROM fa_transaction_headers TH,
2157: fa_books BO
2158: WHERE BO.transaction_header_id_in = TH.transaction_header_id
2159: AND BO.book_type_code = TH.book_type_code
2160: AND BO.asset_id = TH.asset_id
2199: SELECT TH.transaction_type_code,
2200: TH.transaction_header_id,
2201: TH.transaction_date_entered,
2202: decode(debit_credit_flag,'CR',(-1*AD.ADJUSTMENT_AMOUNT),AD.ADJUSTMENT_AMOUNT) ADJUSTMENT_AMOUNT
2203: FROM fa_transaction_headers TH,
2204: fa_ADJUSTMENTS AD
2205: WHERE AD.transaction_header_id = TH.transaction_header_id
2206: AND AD.book_type_code = TH.book_type_code
2207: AND AD.asset_id = TH.asset_id
2252: SELECT TH.transaction_type_code,
2253: TH.transaction_header_id,
2254: th.transaction_date_entered,
2255: RE.cost_retired
2256: FROM fa_transaction_headers TH,
2257: fa_retirements RE
2258: WHERE (RE.transaction_header_id_in = TH.transaction_header_id
2259: OR RE.transaction_header_id_out = TH.transaction_header_id)
2260: AND RE.book_type_code = TH.book_type_code
2304: TH.transaction_header_id,
2305: TH.transaction_date_entered,
2306: decode(debit_credit_flag,'CR',(-1*sum(AD.ADJUSTMENT_AMOUNT)),sum(AD.ADJUSTMENT_AMOUNT)) ADJUSTMENT_AMOUNT
2307: -- SUM(AD.adjustment_amount) adjustment_amount
2308: FROM fa_transaction_headers TH,
2309: fa_adjustments AD
2310: WHERE AD.transaction_header_id = TH.transaction_header_id
2311: AND AD.book_type_code = TH.book_type_code
2312: AND AD.asset_id = TH.asset_id