APPS.JE_JEHUFDAN_XMLP_PKG dependencies on FA_LOOKUPS

Line 206: DELETE FROM FA_LOOKUPS_B

202: AND P2.BOOK_TYPE_CODE = P_BOOK
203: AND P2.PERIOD_NAME = P_PERIOD2;
204: CP_BALANCE_TYPE := 'CR';
205: DELETE FROM JE_HU_BALANCES_REPORT;
206: DELETE FROM FA_LOOKUPS_B
207: WHERE LOOKUP_TYPE = 'REPORT TYPE';
208: DELETE FROM FA_LOOKUPS_TL
209: WHERE LOOKUP_TYPE = 'REPORT TYPE';
210: INSERT INTO FA_LOOKUPS_B

Line 208: DELETE FROM FA_LOOKUPS_TL

204: CP_BALANCE_TYPE := 'CR';
205: DELETE FROM JE_HU_BALANCES_REPORT;
206: DELETE FROM FA_LOOKUPS_B
207: WHERE LOOKUP_TYPE = 'REPORT TYPE';
208: DELETE FROM FA_LOOKUPS_TL
209: WHERE LOOKUP_TYPE = 'REPORT TYPE';
210: INSERT INTO FA_LOOKUPS_B
211: (LOOKUP_TYPE
212: ,LOOKUP_CODE

Line 210: INSERT INTO FA_LOOKUPS_B

206: DELETE FROM FA_LOOKUPS_B
207: WHERE LOOKUP_TYPE = 'REPORT TYPE';
208: DELETE FROM FA_LOOKUPS_TL
209: WHERE LOOKUP_TYPE = 'REPORT TYPE';
210: INSERT INTO FA_LOOKUPS_B
211: (LOOKUP_TYPE
212: ,LOOKUP_CODE
213: ,LAST_UPDATED_BY
214: ,LAST_UPDATE_DATE

Line 221: INSERT INTO FA_LOOKUPS_TL

217: ,P_REPORT_TYPE
218: ,1
219: ,SYSDATE
220: ,'Y');
221: INSERT INTO FA_LOOKUPS_TL
222: (LOOKUP_TYPE
223: ,LOOKUP_CODE
224: ,LANGUAGE
225: ,SOURCE_LANG

Line 274: FA_LOOKUPS RT,

270: ,CP_BALANCE_TYPE
271: ,1
272: ,-1) * AJ.ADJUSTMENT_AMOUNT)
273: FROM
274: FA_LOOKUPS RT,
275: FA_DISTRIBUTION_HISTORY DH,
276: FA_TRANSACTION_HEADERS TH,
277: FA_ASSET_HISTORY AH,
278: FA_ADJUSTMENTS AJ

Line 383: FA_LOOKUPS RT,

379: ,CP_BALANCE_TYPE
380: ,1
381: ,-1) * AJ.ADJUSTMENT_AMOUNT)
382: FROM
383: FA_LOOKUPS RT,
384: FA_DISTRIBUTION_HISTORY DH,
385: FA_TRANSACTION_HEADERS TH,
386: FA_ASSET_HISTORY AH,
387: FA_ADJUSTMENTS AJ,

Line 458: FA_LOOKUPS RT,

454: ,CP_BALANCE_TYPE
455: ,-1
456: ,1) * AJ.ADJUSTMENT_AMOUNT)
457: FROM
458: FA_LOOKUPS RT,
459: FA_DISTRIBUTION_HISTORY DH,
460: FA_CATEGORY_BOOKS CB,
461: FA_TRANSACTION_HEADERS TH,
462: FA_ASSET_HISTORY AH,

Line 464: FA_LOOKUPS LO,

460: FA_CATEGORY_BOOKS CB,
461: FA_TRANSACTION_HEADERS TH,
462: FA_ASSET_HISTORY AH,
463: FA_ADJUSTMENTS AJ,
464: FA_LOOKUPS LO,
465: FA_METHODS ME,
466: FA_BOOKS BO
467: WHERE RT.LOOKUP_TYPE = 'REPORT TYPE'
468: AND RT.LOOKUP_CODE = P_REPORT_TYPE

Line 532: FA_LOOKUPS RT,

528: ,DD.DEPRN_AMOUNT
529: ,'REVAL RESERVE'
530: ,-DD.REVAL_AMORTIZATION))
531: FROM
532: FA_LOOKUPS RT,
533: FA_CATEGORY_BOOKS CB,
534: FA_DISTRIBUTION_HISTORY DH,
535: FA_ASSET_HISTORY AH,
536: FA_DEPRN_DETAIL DD,

Line 608: FA_LOOKUPS RT,

604: ,DD.DEPRN_AMOUNT
605: ,'REVAL RESERVE'
606: ,-DD.REVAL_AMORTIZATION))
607: FROM
608: FA_LOOKUPS RT,
609: FA_CATEGORY_BOOKS CB,
610: FA_DISTRIBUTION_HISTORY DH,
611: FA_ASSET_HISTORY AH,
612: FA_DEPRN_DETAIL DD,

Line 699: FA_LOOKUPS RT,

695: ,DD.DEPRN_AMOUNT
696: ,'REVAL RESERVE'
697: ,-DD.REVAL_AMORTIZATION))
698: FROM
699: FA_LOOKUPS RT,
700: FA_CATEGORY_BOOKS CB,
701: FA_DISTRIBUTION_HISTORY DH,
702: FA_ASSET_HISTORY AH,
703: FA_DEPRN_DETAIL DD,

Line 794: FA_LOOKUPS RT,

790: ,CP_BALANCE_TYPE
791: ,-1
792: ,1) * AJ.ADJUSTMENT_AMOUNT)
793: FROM
794: FA_LOOKUPS RT,
795: FA_DISTRIBUTION_HISTORY DH,
796: FA_CATEGORY_BOOKS CB,
797: FA_TRANSACTION_HEADERS TH,
798: FA_ASSET_HISTORY AH,

Line 800: FA_LOOKUPS LO,

796: FA_CATEGORY_BOOKS CB,
797: FA_TRANSACTION_HEADERS TH,
798: FA_ASSET_HISTORY AH,
799: FA_ADJUSTMENTS AJ,
800: FA_LOOKUPS LO,
801: FA_METHODS ME,
802: FA_BOOKS BO
803: WHERE RT.LOOKUP_TYPE = 'REPORT TYPE'
804: AND RT.LOOKUP_CODE = P_REPORT_TYPE

Line 872: FA_LOOKUPS RT,

868: 'FIRST STR',
869: SUM(NVL(DD.DEPRN_ADJUSTMENT_AMOUNT
870: ,0))
871: FROM
872: FA_LOOKUPS RT,
873: FA_CATEGORY_BOOKS CB,
874: FA_DISTRIBUTION_HISTORY DH,
875: FA_ASSET_HISTORY AH,
876: FA_DEPRN_DETAIL DD,

Line 950: FA_LOOKUPS RT,

946: 'FIRST NON STR',
947: SUM(NVL(DD.DEPRN_ADJUSTMENT_AMOUNT
948: ,0))
949: FROM
950: FA_LOOKUPS RT,
951: FA_CATEGORY_BOOKS CB,
952: FA_DISTRIBUTION_HISTORY DH,
953: FA_ASSET_HISTORY AH,
954: FA_DEPRN_DETAIL DD,