APPS.FA_FAS401_XMLP_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 403: FA_DISTRIBUTION_HISTORY DH,

399: FA_ASSET_HISTORY AH,
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

Line 468: FA_DISTRIBUTION_HISTORY DH,

464: FA_ASSET_HISTORY AH,
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

Line 560: FA_DISTRIBUTION_HISTORY DH,

556: FA_ASSET_HISTORY AH,
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

Line 625: FA_DISTRIBUTION_HISTORY DH,

621: FA_ASSET_HISTORY AH,
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

Line 720: FA_DISTRIBUTION_HISTORY DH,

716: FA_ASSET_HISTORY AH,
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

Line 814: FA_DISTRIBUTION_HISTORY DH,

810: FA_ASSET_HISTORY AH,
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