APPS.FA_FAS400_XMLP_PKG dependencies on FA_CATEGORY_BOOKS

Line 467: FA_CATEGORY_BOOKS CB

463: FA_TRANSACTION_HEADERS TH,
464: FA_TRANSACTION_HEADERS TH_RT,
465: FA_BOOKS_MRC_V BOOKS,
466: FA_DISTRIBUTION_HISTORY DH,
467: FA_CATEGORY_BOOKS CB
468: WHERE
469: CB.BOOK_TYPE_CODE = book AND
470: CB.CATEGORY_ID = AH.CATEGORY_ID
471: AND

Line 532: FA_CATEGORY_BOOKS CB

528: FA_TRANSACTION_HEADERS TH,
529: FA_TRANSACTION_HEADERS TH_RT,
530: FA_BOOKS_MRC_V BOOKS,
531: FA_DISTRIBUTION_HISTORY DH,
532: FA_CATEGORY_BOOKS CB
533: WHERE
534: CB.BOOK_TYPE_CODE = book AND
535: CB.CATEGORY_ID = AH.CATEGORY_ID
536: AND

Line 624: FA_CATEGORY_BOOKS CB

620: FA_TRANSACTION_HEADERS TH,
621: FA_TRANSACTION_HEADERS TH_RT,
622: FA_BOOKS BOOKS,
623: FA_DISTRIBUTION_HISTORY DH,
624: FA_CATEGORY_BOOKS CB
625: WHERE
626: CB.BOOK_TYPE_CODE = book AND
627: CB.CATEGORY_ID = AH.CATEGORY_ID
628: AND

Line 689: FA_CATEGORY_BOOKS CB

685: FA_TRANSACTION_HEADERS TH,
686: FA_TRANSACTION_HEADERS TH_RT,
687: FA_BOOKS BOOKS,
688: FA_DISTRIBUTION_HISTORY DH,
689: FA_CATEGORY_BOOKS CB
690: WHERE
691: CB.BOOK_TYPE_CODE = book AND
692: CB.CATEGORY_ID = AH.CATEGORY_ID
693: AND

Line 784: FA_CATEGORY_BOOKS CB

780: FA_TRANSACTION_HEADERS TH,
781: FA_TRANSACTION_HEADERS TH_RT,
782: FA_BOOKS_MRC_V BOOKS,
783: FA_DISTRIBUTION_HISTORY DH,
784: FA_CATEGORY_BOOKS CB
785: WHERE
786: -- start cua - exclude the group Assets
787: books.group_asset_id is null
788: AND -- end cua

Line 878: FA_CATEGORY_BOOKS CB

874: FA_TRANSACTION_HEADERS TH,
875: FA_TRANSACTION_HEADERS TH_RT,
876: FA_BOOKS BOOKS,
877: FA_DISTRIBUTION_HISTORY DH,
878: FA_CATEGORY_BOOKS CB
879: WHERE
880: -- start cua - exclude the group Assets
881: books.group_asset_id is null
882: AND -- end cua