APPS.FARX_BL dependencies on FA_LOOKUPS

Line 219: FA_LOOKUPS LU

215: FA_ADDITIONS AD,
216: GL_CODE_COMBINATIONS DHCC,
217: GL_CODE_COMBINATIONS AJCC,
218: FA_ADDITIONS AD1,
219: FA_LOOKUPS LU
220: WHERE AD.Asset_ID = BAL.Asset_ID
221: AND DHCC.Code_Combination_ID = BAL.Distribution_CCID
222: AND AJCC.Code_Combination_ID (+) = BAL.Adjustment_CCID
223: AND B.ASSET_ID = AD.ASSET_ID

Line 304: FA_LOOKUPS LU

300: FA_ADDITIONS AD,
301: GL_CODE_COMBINATIONS DHCC,
302: GL_CODE_COMBINATIONS AJCC,
303: FA_ADDITIONS AD1, -- This is only used to get Group Asset Number
304: FA_LOOKUPS LU
305: WHERE AD.Asset_ID = BAL.Asset_ID
306: AND DHCC.Code_Combination_ID = BAL.Distribution_CCID
307: AND AJCC.Code_Combination_ID (+) = BAL.Adjustment_CCID
308: AND B.Book_Type_Code = c_book /* StatReq */

Line 501: h_table_token := 'FA_LOOKUPS';

497:
498: -- no longer needed with GT
499: -- DELETE FROM FA_BALANCES_REPORT_GT;
500:
501: h_table_token := 'FA_LOOKUPS';
502:
503: -- bug 1068054
504:
505: Delete from fa_lookups_b

Line 505: Delete from fa_lookups_b

501: h_table_token := 'FA_LOOKUPS';
502:
503: -- bug 1068054
504:
505: Delete from fa_lookups_b
506: where lookup_type = 'REPORT TYPE';
507:
508:
509: Delete from fa_lookups_tl

Line 509: Delete from fa_lookups_tl

505: Delete from fa_lookups_b
506: where lookup_type = 'REPORT TYPE';
507:
508:
509: Delete from fa_lookups_tl
510: where lookup_type = 'REPORT TYPE';
511:
512:
513: h_mesg_name := 'FA_SHARED_INSERT_FAILED';

Line 516: INSERT INTO FA_LOOKUPS_B

512:
513: h_mesg_name := 'FA_SHARED_INSERT_FAILED';
514: -- bug 1068054
515:
516: INSERT INTO FA_LOOKUPS_B
517: (lookup_type,
518: lookup_code,
519: last_updated_by,
520: last_update_date,

Line 529: insert into FA_LOOKUPS_TL (

525: 1,
526: SYSDATE,
527: 'Y');
528:
529: insert into FA_LOOKUPS_TL (
530: LOOKUP_TYPE,
531: LOOKUP_CODE,
532: MEANING,
533: LAST_UPDATE_DATE,

Line 548: from FA_LOOKUPS_TL T

544: from FND_LANGUAGES L
545: where L.INSTALLED_FLAG in ('I', 'B')
546: and not exists
547: (select NULL
548: from FA_LOOKUPS_TL T
549: where T.LOOKUP_TYPE = 'REPORT TYPE'
550: and T.LOOKUP_CODE = Report_Type
551: and T.LANGUAGE = L.LANGUAGE_CODE);
552:

Line 835: FROM FA_LOOKUPS RT,

831: CB.Asset_Cost_Acct,
832: AJ.Source_Type_Code,
833: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
834: AJ.Adjustment_Amount)
835: FROM FA_LOOKUPS RT,
836: FA_CATEGORY_BOOKS CB,
837: FA_ASSET_HISTORY AH1,
838: FA_DISTRIBUTION_HISTORY DH,
839: FA_TRANSACTION_HEADERS TH,

Line 935: FROM FA_LOOKUPS RT,

931: 'D', 'DEPRECIATION', 'T', 'DEPRECIATION', 'ADDITION'),
932: SUM (DECODE (RT.Lookup_Code,
933: 'RESERVE', DD.Deprn_Amount,
934: 'REVAL RESERVE', -DD.Reval_Amortization))
935: FROM FA_LOOKUPS RT,
936: FA_CATEGORY_BOOKS CB,
937: FA_DISTRIBUTION_HISTORY DH,
938: FA_ASSET_HISTORY AH,
939: FA_DEPRN_DETAIL DD,