APPS.FA_FAS403_XMLP_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 443: FA_DISTRIBUTION_HISTORY DH,

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

Line 508: FA_DISTRIBUTION_HISTORY DH,

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

Line 600: FA_DISTRIBUTION_HISTORY DH,

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

Line 665: FA_DISTRIBUTION_HISTORY DH,

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

Line 760: FA_DISTRIBUTION_HISTORY DH,

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

Line 854: FA_DISTRIBUTION_HISTORY DH,

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