APPS.FARX_AL dependencies on FA_DEPRN_DETAIL_MRC_V

Line 809: FA_DEPRN_DETAIL_mrc_v DD,

805: DD.DEPRN_RESERVE RESERVE,
806: DECODE(DD.PERIOD_COUNTER, upc, DD.DEPRN_AMOUNT,0) DEPRN_AMOUNT,
807: DH.UNITS_ASSIGNED UNITS
808: FROM
809: FA_DEPRN_DETAIL_mrc_v DD,
810: FA_DISTRIBUTION_HISTORY DH,
811: FA_BOOK_CONTROLS_mrc_v BC -- Added for Bug#2675646
812: WHERE
813: DD.ASSET_ID = h_asset_id AND

Line 818: FROM FA_DEPRN_DETAIL_mrc_v DD2

814: DD.BOOK_TYPE_CODE = h_book AND
815: DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND
816: DD.PERIOD_COUNTER =
817: (SELECT MAX(DD2.PERIOD_COUNTER)
818: FROM FA_DEPRN_DETAIL_mrc_v DD2
819: WHERE DD2.BOOK_TYPE_CODE = h_book
820: AND DD2.ASSET_ID = h_asset_id
821: AND DD2.DISTRIBUTION_ID = DD.DISTRIBUTION_ID
822: AND DD2.PERIOD_COUNTER <= upc)

Line 841: FA_DEPRN_DETAIL_mrc_v DD,

837: 0 RESERVE,
838: DECODE(DD.PERIOD_COUNTER, upc, DD.DEPRN_AMOUNT,0) DEPRN_AMOUNT,
839: 0 UNITS
840: FROM
841: FA_DEPRN_DETAIL_mrc_v DD,
842: FA_DISTRIBUTION_HISTORY DH,
843: FA_DISTRIBUTION_HISTORY DH_PRIOR,
844: FA_BOOK_CONTROLS_mrc_v BC -- Added for Bug#2675646
845: WHERE

Line 852: FROM FA_DEPRN_DETAIL_mrc_v DD2

848: DD.DISTRIBUTION_ID = DH_PRIOR.DISTRIBUTION_ID AND
849: DH.CODE_COMBINATION_ID = DH_PRIOR.CODE_COMBINATION_ID AND /* Added for Bug 12996138 */
850: DD.PERIOD_COUNTER =
851: (SELECT MAX(DD2.PERIOD_COUNTER)
852: FROM FA_DEPRN_DETAIL_mrc_v DD2
853: WHERE DD2.BOOK_TYPE_CODE = h_book
854: AND DD2.ASSET_ID = h_asset_id
855: AND DD2.DISTRIBUTION_ID = DD.DISTRIBUTION_ID
856: AND DD2.PERIOD_COUNTER <= upc)

Line 915: (NOT EXISTS (SELECT 1 FROM FA_DEPRN_DETAIL_mrc_v DD

911: DH.DATE_EFFECTIVE <= ucd AND
912: nvl(DH.DATE_INEFFECTIVE, ucd+1) > ucd AND
913: (DH.ASSIGNED_to = h_assigned_to OR
914: (DH.ASSIGNED_TO is null and h_assigned_to is null)) AND
915: (NOT EXISTS (SELECT 1 FROM FA_DEPRN_DETAIL_mrc_v DD
916: WHERE DD.ASSET_ID = h_asset_id
917: AND DD.BOOK_TYPE_CODE = h_book
918: AND DD.PERIOD_COUNTER = upc)));
919: END if;