APPS.FARX_AL dependencies on FA_DEPRN_DETAIL

Line 680: FA_DEPRN_DETAIL DD,

676: DD.DEPRN_RESERVE RESERVE,
677: DECODE(DD.PERIOD_COUNTER, upc, DD.DEPRN_AMOUNT,0) DEPRN_AMOUNT,
678: DH.UNITS_ASSIGNED UNITS
679: FROM
680: FA_DEPRN_DETAIL DD,
681: FA_DISTRIBUTION_HISTORY DH,
682: FA_BOOK_CONTROLS BC -- Added for Bug#2675646
683: WHERE
684: DD.ASSET_ID = h_asset_id AND

Line 689: FROM FA_DEPRN_DETAIL DD2

685: DD.BOOK_TYPE_CODE = h_book AND
686: DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND
687: DD.PERIOD_COUNTER =
688: (SELECT MAX(DD2.PERIOD_COUNTER)
689: FROM FA_DEPRN_DETAIL DD2
690: WHERE DD2.BOOK_TYPE_CODE = h_book
691: AND DD2.ASSET_ID = h_asset_id
692: AND DD2.DISTRIBUTION_ID = DD.DISTRIBUTION_ID
693: AND DD2.PERIOD_COUNTER <= upc)

Line 712: FA_DEPRN_DETAIL DD,

708: 0 RESERVE,
709: DECODE(DD.PERIOD_COUNTER, upc, DD.DEPRN_AMOUNT,0) DEPRN_AMOUNT,
710: 0 UNITS
711: FROM
712: FA_DEPRN_DETAIL DD,
713: FA_DISTRIBUTION_HISTORY DH,
714: FA_DISTRIBUTION_HISTORY DH_PRIOR,
715: FA_BOOK_CONTROLS BC -- Added for Bug#2675646
716: WHERE

Line 722: FROM FA_DEPRN_DETAIL DD2

718: DD.BOOK_TYPE_CODE = h_book AND
719: DD.DISTRIBUTION_ID = DH_PRIOR.DISTRIBUTION_ID AND
720: DD.PERIOD_COUNTER =
721: (SELECT MAX(DD2.PERIOD_COUNTER)
722: FROM FA_DEPRN_DETAIL DD2
723: WHERE DD2.BOOK_TYPE_CODE = h_book
724: AND DD2.ASSET_ID = h_asset_id
725: AND DD2.DISTRIBUTION_ID = DD.DISTRIBUTION_ID
726: AND DD2.PERIOD_COUNTER <= upc)

Line 784: (NOT EXISTS (SELECT 1 FROM FA_DEPRN_DETAIL DD

780: DH.DATE_EFFECTIVE <= ucd AND
781: nvl(DH.DATE_INEFFECTIVE, ucd+1) > ucd AND
782: (DH.ASSIGNED_to = h_assigned_to OR
783: (DH.ASSIGNED_TO is null and h_assigned_to is null)) AND
784: (NOT EXISTS (SELECT 1 FROM FA_DEPRN_DETAIL DD
785: WHERE DD.ASSET_ID = h_asset_id
786: AND DD.BOOK_TYPE_CODE = h_book
787: AND DD.PERIOD_COUNTER = upc)));
788: else/* else */

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;