DBA Data[Home] [Help]

APPS.FARX_AJ dependencies on FA_DISTRIBUTION_HISTORY

Line 126: FA_DISTRIBUTION_HISTORY DH,

122: ( select full_name name, employee_number, person_id employee_id
123: from per_people_f
124: where TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
125: ) EMP,
126: FA_DISTRIBUTION_HISTORY DH,
127: FA_ASSET_HISTORY AH,
128: FA_CATEGORY_BOOKS CAT_BK,
129: FA_LOOKUPS FALU,
130: PO_VENDORS PO_IN,

Line 465: fa_distribution_history dh,

461: po_vendors po_ai_in,
462: fa_lookups lu,
463: gl_code_combinations glcc_ar,
464: fa_additions ad,
465: fa_distribution_history dh,
466: fa_asset_history ah,
467: fa_asset_invoices ai_in,
468: fa_transaction_headers th
469: where

Line 521: fa_distribution_history dh,

517: po_vendors po_ai_in,
518: fa_lookups lu,
519: gl_code_combinations glcc_ar,
520: fa_additions ad,
521: fa_distribution_history dh,
522: fa_asset_history ah,
523: fa_asset_invoices ai_in,
524: fa_transaction_headers th
525: where

Line 577: fa_distribution_history dh,

573: from po_vendors po_ai_in,
574: fa_lookups lu,
575: gl_code_combinations glcc_ar,
576: fa_additions ad,
577: fa_distribution_history dh,
578: fa_asset_history ah,
579: fa_invoice_transactions it,
580: fa_asset_invoices ai_in,
581: fa_transaction_headers tht,

Line 645: fa_distribution_history dh,

641: * (nvl (dh.units_assigned, ah.units) /
642: ah.units))
643: from po_vendors po_ai_in,
644: fa_lookups lu,
645: fa_distribution_history dh,
646: gl_code_combinations glcc_fa,
647: gl_code_combinations glcc_ar,
648: fa_additions ad,
649: fa_asset_history ah,

Line 712: fa_distribution_history dh,

708: round(sum((bk_in.cost - nvl(bk_out.cost,0)) *
709: dh.units_assigned / ah.units),2)
710: from fa_books bk_in,
711: fa_books bk_out,
712: fa_distribution_history dh,
713: fa_lookups lu,
714: gl_code_combinations glcc_fa,
715: gl_code_combinations glcc_ar,
716: fa_additions ad,

Line 801: fa_distribution_history dh,

797: * (dh.units_assigned / ah.units)),2)
798: from fa_asset_invoices ai_out,
799: po_vendors po_ai_in,
800: fa_lookups lu,
801: fa_distribution_history dh,
802: gl_code_combinations glcc_fa,
803: gl_code_combinations glcc_ar,
804: fa_additions ad,
805: fa_asset_history ah,

Line 888: fa_distribution_history dh,

884: * (dh.units_assigned / ah.units)),2)
885: from fa_asset_invoices ai_out,
886: po_vendors po_ai_in,
887: fa_lookups lu,
888: fa_distribution_history dh,
889: gl_code_combinations glcc_fa,
890: gl_code_combinations glcc_ar,
891: fa_additions ad,
892: fa_asset_history ah,