DBA Data[Home] [Help]

APPS.FARX_AJ dependencies on FA_LOOKUPS

Line 129: FA_LOOKUPS FALU,

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,
131: PO_VENDORS PO_OUT,
132: FA_ADDITIONS AD,
133: GL_CODE_COMBINATIONS DHCC,

Line 462: fa_lookups lu,

458: ai_in.description,
459: sum(nvl(ai_in.payables_cost,0) * nvl(dh.units_assigned, ah.units) / ah.units )
460: from
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,

Line 518: fa_lookups lu,

514: ai_in.description,
515: sum(nvl(ai_in.payables_cost,0) * nvl(dh.units_assigned, ah.units) / ah.units )
516: from
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,

Line 574: fa_lookups lu,

570: --ai_in.ap_distribution_line_number,
571: ai_in.description,
572: sum(nvl(ai_in.payables_cost,0) * nvl(dh.units_assigned, ah.units) / ah.units )
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,

Line 644: fa_lookups lu,

640: nvl(ai_in.payables_cost, 0))
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,

Line 713: fa_lookups lu,

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,
717: fa_asset_history ah,

Line 800: fa_lookups lu,

796: nvl(ai_in.payables_cost, 0))
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,

Line 887: fa_lookups lu,

883: -nvl(ai_out.fixed_assets_cost,0),0)
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,