APPS.FA_FAS480_XMLP_PKG dependencies on FA_CATEGORY_BOOKS

Line 480: FA_CATEGORY_BOOKS CB

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
484: AND

Line 545: FA_CATEGORY_BOOKS CB

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
549: AND

Line 637: FA_CATEGORY_BOOKS CB

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
641: AND

Line 702: FA_CATEGORY_BOOKS CB

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
706: AND

Line 797: FA_CATEGORY_BOOKS CB

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
801: AND -- end cua

Line 891: FA_CATEGORY_BOOKS CB

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
895: AND -- end cua