APPS.FARX_BL dependencies on FA_LOOKUPS

Line 161: h_group_asset FA_LOOKUPS.MEANING%TYPE; --bug8432604 -- Group Asset_number

157: acct_prompt VARCHAR2(240); /* StatReq */
158: acct_valueset_name VARCHAR2(240); /* StatReq */
159:
160: -- Additional variables for Drill Down Report
161: h_group_asset FA_LOOKUPS.MEANING%TYPE; --bug8432604 -- Group Asset_number
162:
163: -- MRC
164: h_sob_id NUMBER;
165: h_mrcsobtype VARCHAR2(1);

Line 227: FA_LOOKUPS LU

223: FA_ADDITIONS AD,
224: GL_CODE_COMBINATIONS DHCC,
225: GL_CODE_COMBINATIONS AJCC,
226: FA_ADDITIONS AD1,
227: FA_LOOKUPS LU
228: WHERE AD.Asset_ID = BAL.Asset_ID
229: AND DHCC.Code_Combination_ID = BAL.Distribution_CCID
230: AND AJCC.Code_Combination_ID (+) = BAL.Adjustment_CCID
231: AND B.ASSET_ID = AD.ASSET_ID

Line 338: FA_LOOKUPS LU

334: FA_ADDITIONS AD,
335: GL_CODE_COMBINATIONS DHCC,
336: GL_CODE_COMBINATIONS AJCC,
337: FA_ADDITIONS AD1,
338: FA_LOOKUPS LU
339: WHERE AD.Asset_ID = BAL.Asset_ID
340: AND DHCC.Code_Combination_ID = BAL.Distribution_CCID
341: AND AJCC.Code_Combination_ID (+) = BAL.Adjustment_CCID
342: AND B.ASSET_ID = AD.ASSET_ID

Line 451: FA_LOOKUPS LU,

447: FA_ADDITIONS AD,
448: GL_CODE_COMBINATIONS DHCC,
449: GL_CODE_COMBINATIONS AJCC,
450: FA_ADDITIONS AD1, -- This is only used to get Group Asset Number
451: FA_LOOKUPS LU,
452: FA_BOOKS BKG
453: WHERE AD.Asset_ID = BAL.Asset_ID
454: AND DHCC.Code_Combination_ID = BAL.Distribution_CCID
455: AND AJCC.Code_Combination_ID (+) = BAL.Adjustment_CCID

Line 537: FA_LOOKUPS LU,

533: FA_ADDITIONS AD,
534: GL_CODE_COMBINATIONS DHCC,
535: GL_CODE_COMBINATIONS AJCC,
536: FA_ADDITIONS AD1, -- This is only used to get Group Asset Number
537: FA_LOOKUPS LU,
538: FA_MC_BOOKS BKG
539: WHERE AD.Asset_ID = BAL.Asset_ID
540: AND DHCC.Code_Combination_ID = BAL.Distribution_CCID
541: AND AJCC.Code_Combination_ID (+) = BAL.Adjustment_CCID

Line 764: h_table_token := 'FA_LOOKUPS';

760:
761: -- no longer needed with GT
762: -- DELETE FROM FA_BALANCES_REPORT_GT;
763:
764: h_table_token := 'FA_LOOKUPS';
765:
766: /* StatReq - Added category flex structure to the following
767: SQL Statement */
768: select