APPS.FA_FAS401_XMLP_PKG dependencies on FA_CATEGORY_BOOKS

Line 404: FA_CATEGORY_BOOKS CB

400: FA_TRANSACTION_HEADERS TH,
401: FA_TRANSACTION_HEADERS TH_RT,
402: FA_BOOKS_MRC_V BOOKS,
403: FA_DISTRIBUTION_HISTORY DH,
404: FA_CATEGORY_BOOKS CB
405: WHERE
406: CB.BOOK_TYPE_CODE = book AND
407: CB.CATEGORY_ID = AH.CATEGORY_ID
408: AND

Line 469: FA_CATEGORY_BOOKS CB

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

Line 561: FA_CATEGORY_BOOKS CB

557: FA_TRANSACTION_HEADERS TH,
558: FA_TRANSACTION_HEADERS TH_RT,
559: FA_BOOKS BOOKS,
560: FA_DISTRIBUTION_HISTORY DH,
561: FA_CATEGORY_BOOKS CB
562: WHERE
563: CB.BOOK_TYPE_CODE = book AND
564: CB.CATEGORY_ID = AH.CATEGORY_ID
565: AND

Line 626: FA_CATEGORY_BOOKS CB

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

Line 721: FA_CATEGORY_BOOKS CB

717: FA_TRANSACTION_HEADERS TH,
718: FA_TRANSACTION_HEADERS TH_RT,
719: FA_BOOKS_MRC_V BOOKS,
720: FA_DISTRIBUTION_HISTORY DH,
721: FA_CATEGORY_BOOKS CB
722: WHERE
723: -- start cua - exclude the group Assets
724: books.group_asset_id is null
725: AND -- end cua

Line 815: FA_CATEGORY_BOOKS CB

811: FA_TRANSACTION_HEADERS TH,
812: FA_TRANSACTION_HEADERS TH_RT,
813: FA_BOOKS BOOKS,
814: FA_DISTRIBUTION_HISTORY DH,
815: FA_CATEGORY_BOOKS CB
816: WHERE
817: -- start cua - exclude the group Assets
818: books.group_asset_id is null
819: AND -- end cua