APPS.FARX_AL dependencies on FA_DEPRN_DETAIL_MRC_V

Line 807: FA_DEPRN_DETAIL_mrc_v DD,

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

Line 816: FROM FA_DEPRN_DETAIL_mrc_v DD2

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

Line 839: FA_DEPRN_DETAIL_mrc_v DD,

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

Line 849: FROM FA_DEPRN_DETAIL_mrc_v DD2

845: DD.BOOK_TYPE_CODE = h_book AND
846: DD.DISTRIBUTION_ID = DH_PRIOR.DISTRIBUTION_ID AND
847: DD.PERIOD_COUNTER =
848: (SELECT MAX(DD2.PERIOD_COUNTER)
849: FROM FA_DEPRN_DETAIL_mrc_v DD2
850: WHERE DD2.BOOK_TYPE_CODE = h_book
851: AND DD2.ASSET_ID = h_asset_id
852: AND DD2.DISTRIBUTION_ID = DD.DISTRIBUTION_ID
853: AND DD2.PERIOD_COUNTER <= upc)

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

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