APPS.FA_FAS400_XMLP_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 466: FA_DISTRIBUTION_HISTORY DH,

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

Line 531: FA_DISTRIBUTION_HISTORY DH,

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

Line 623: FA_DISTRIBUTION_HISTORY DH,

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

Line 688: FA_DISTRIBUTION_HISTORY DH,

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

Line 783: FA_DISTRIBUTION_HISTORY DH,

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

Line 877: FA_DISTRIBUTION_HISTORY DH,

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