DBA Data[Home] [Help]

APPS.FA_RSVLDG_REP_INS_PKG dependencies on FA_DEPRN_PERIODS_MRC_V

Line 50: FA_DEPRN_PERIODS_MRC_V DP,

46: upc,
47: tod,
48: tpc
49: FROM
50: FA_DEPRN_PERIODS_MRC_V DP,
51: FA_DEPRN_PERIODS_MRC_V DP_FY,
52: FA_BOOK_CONTROLS_MRC_V BC
53: WHERE
54: DP.BOOK_TYPE_CODE = book AND

Line 51: FA_DEPRN_PERIODS_MRC_V DP_FY,

47: tod,
48: tpc
49: FROM
50: FA_DEPRN_PERIODS_MRC_V DP,
51: FA_DEPRN_PERIODS_MRC_V DP_FY,
52: FA_BOOK_CONTROLS_MRC_V BC
53: WHERE
54: DP.BOOK_TYPE_CODE = book AND
55: DP.PERIOD_NAME = period AND

Line 1009: FA_DEPRN_PERIODS_MRC_V DP

1005: FROM
1006: FA_DEPRN_SUMMARY_MRC_V DD,
1007: FA_GROUP_ASSET_RULES GAR,
1008: FA_GROUP_ASSET_DEFAULT GAD,
1009: FA_DEPRN_PERIODS_MRC_V DP
1010: WHERE
1011: DD.BOOK_TYPE_CODE = book
1012: AND DD.ASSET_ID = GAR.GROUP_ASSET_ID
1013: AND GAD.SUPER_GROUP_ID is null -- MPOWELL

Line 1148: FA_DEPRN_PERIODS_MRC_V DP

1144: FROM FA_DEPRN_SUMMARY_MRC_V DD,
1145: fa_GROUP_ASSET_RULES GAR,
1146: fa_GROUP_ASSET_DEFAULT GAD,
1147: fa_SUPER_GROUP_RULES SGR,
1148: FA_DEPRN_PERIODS_MRC_V DP
1149: WHERE DD.BOOK_TYPE_CODE = book
1150: AND DD.ASSET_ID = GAR.GROUP_ASSET_ID
1151: AND GAR.BOOK_TYPE_CODE = DD.BOOK_TYPE_CODE
1152: AND GAD.SUPER_GROUP_ID = SGR.SUPER_GROUP_ID -- MPOWELL