APPS.FA_FAS480_XMLP_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 479: FA_DISTRIBUTION_HISTORY DH,

475: FA_ASSET_HISTORY AH,
476: FA_TRANSACTION_HEADERS TH,
477: FA_TRANSACTION_HEADERS TH_RT,
478: FA_BOOKS_MRC_V BOOKS,
479: FA_DISTRIBUTION_HISTORY DH,
480: FA_CATEGORY_BOOKS CB
481: WHERE
482: CB.BOOK_TYPE_CODE = book AND
483: CB.CATEGORY_ID = AH.CATEGORY_ID

Line 544: FA_DISTRIBUTION_HISTORY DH,

540: FA_ASSET_HISTORY AH,
541: FA_TRANSACTION_HEADERS TH,
542: FA_TRANSACTION_HEADERS TH_RT,
543: FA_BOOKS_MRC_V BOOKS,
544: FA_DISTRIBUTION_HISTORY DH,
545: FA_CATEGORY_BOOKS CB
546: WHERE
547: CB.BOOK_TYPE_CODE = book AND
548: CB.CATEGORY_ID = AH.CATEGORY_ID

Line 636: FA_DISTRIBUTION_HISTORY DH,

632: FA_ASSET_HISTORY AH,
633: FA_TRANSACTION_HEADERS TH,
634: FA_TRANSACTION_HEADERS TH_RT,
635: FA_BOOKS BOOKS,
636: FA_DISTRIBUTION_HISTORY DH,
637: FA_CATEGORY_BOOKS CB
638: WHERE
639: CB.BOOK_TYPE_CODE = book AND
640: CB.CATEGORY_ID = AH.CATEGORY_ID

Line 701: FA_DISTRIBUTION_HISTORY DH,

697: FA_ASSET_HISTORY AH,
698: FA_TRANSACTION_HEADERS TH,
699: FA_TRANSACTION_HEADERS TH_RT,
700: FA_BOOKS BOOKS,
701: FA_DISTRIBUTION_HISTORY DH,
702: FA_CATEGORY_BOOKS CB
703: WHERE
704: CB.BOOK_TYPE_CODE = book AND
705: CB.CATEGORY_ID = AH.CATEGORY_ID

Line 796: FA_DISTRIBUTION_HISTORY DH,

792: FA_ASSET_HISTORY AH,
793: FA_TRANSACTION_HEADERS TH,
794: FA_TRANSACTION_HEADERS TH_RT,
795: FA_BOOKS_MRC_V BOOKS,
796: FA_DISTRIBUTION_HISTORY DH,
797: FA_CATEGORY_BOOKS CB
798: WHERE
799: -- start cua - exclude the group Assets
800: books.group_asset_id is null

Line 890: FA_DISTRIBUTION_HISTORY DH,

886: FA_ASSET_HISTORY AH,
887: FA_TRANSACTION_HEADERS TH,
888: FA_TRANSACTION_HEADERS TH_RT,
889: FA_BOOKS BOOKS,
890: FA_DISTRIBUTION_HISTORY DH,
891: FA_CATEGORY_BOOKS CB
892: WHERE
893: -- start cua - exclude the group Assets
894: books.group_asset_id is null