APPS.FA_FAS403_XMLP_PKG dependencies on FA_CATEGORY_BOOKS

Line 444: FA_CATEGORY_BOOKS CB

440: FA_TRANSACTION_HEADERS TH,
441: FA_TRANSACTION_HEADERS TH_RT,
442: FA_BOOKS_MRC_V BOOKS,
443: FA_DISTRIBUTION_HISTORY DH,
444: FA_CATEGORY_BOOKS CB
445: WHERE
446: CB.BOOK_TYPE_CODE = book AND
447: CB.CATEGORY_ID = AH.CATEGORY_ID
448: AND

Line 509: FA_CATEGORY_BOOKS CB

505: FA_TRANSACTION_HEADERS TH,
506: FA_TRANSACTION_HEADERS TH_RT,
507: FA_BOOKS_MRC_V BOOKS,
508: FA_DISTRIBUTION_HISTORY DH,
509: FA_CATEGORY_BOOKS CB
510: WHERE
511: CB.BOOK_TYPE_CODE = book AND
512: CB.CATEGORY_ID = AH.CATEGORY_ID
513: AND

Line 601: FA_CATEGORY_BOOKS CB

597: FA_TRANSACTION_HEADERS TH,
598: FA_TRANSACTION_HEADERS TH_RT,
599: FA_BOOKS BOOKS,
600: FA_DISTRIBUTION_HISTORY DH,
601: FA_CATEGORY_BOOKS CB
602: WHERE
603: CB.BOOK_TYPE_CODE = book AND
604: CB.CATEGORY_ID = AH.CATEGORY_ID
605: AND

Line 666: FA_CATEGORY_BOOKS CB

662: FA_TRANSACTION_HEADERS TH,
663: FA_TRANSACTION_HEADERS TH_RT,
664: FA_BOOKS BOOKS,
665: FA_DISTRIBUTION_HISTORY DH,
666: FA_CATEGORY_BOOKS CB
667: WHERE
668: CB.BOOK_TYPE_CODE = book AND
669: CB.CATEGORY_ID = AH.CATEGORY_ID
670: AND

Line 761: FA_CATEGORY_BOOKS CB

757: FA_TRANSACTION_HEADERS TH,
758: FA_TRANSACTION_HEADERS TH_RT,
759: FA_BOOKS_MRC_V BOOKS,
760: FA_DISTRIBUTION_HISTORY DH,
761: FA_CATEGORY_BOOKS CB
762: WHERE
763: -- start cua - exclude the group Assets
764: books.group_asset_id is null
765: AND -- end cua

Line 855: FA_CATEGORY_BOOKS CB

851: FA_TRANSACTION_HEADERS TH,
852: FA_TRANSACTION_HEADERS TH_RT,
853: FA_BOOKS BOOKS,
854: FA_DISTRIBUTION_HISTORY DH,
855: FA_CATEGORY_BOOKS CB
856: WHERE
857: -- start cua - exclude the group Assets
858: books.group_asset_id is null
859: AND -- end cua