129: FA_LOOKUPS FALU,
130: PO_VENDORS PO_IN,
131: PO_VENDORS PO_OUT,
132: FA_ADDITIONS AD,
133: GL_CODE_COMBINATIONS DHCC,
134: FA_BOOKS ACTIVE_BK,
135: FA_ADDITIONS_B GAD
136: WHERE
137: TH.TRANSACTION_TYPE_CODE IN ('ADJUSTMENT','CIP ADJUSTMENT') AND
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,
467: fa_asset_invoices ai_in,
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,
523: fa_asset_invoices ai_in,
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,
579: fa_invoice_transactions it,
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,
650: fa_category_books cat_bk,
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,
650: fa_category_books cat_bk,
651: fa_asset_invoices ai_in,
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,
718: fa_category_books cat_bk,
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,
718: fa_category_books cat_bk,
719: fa_transaction_headers th
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,
806: fa_category_books cat_bk,
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,
806: fa_category_books cat_bk,
807: fa_transaction_headers th,
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,
893: fa_category_books cat_bk,
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,
893: fa_category_books cat_bk,
894: fa_transaction_headers th,
968: --ai_in.ap_distribution_line_number,
969: ai_in.description;
970: --propagetd fix for bug 3375136 ends
971:
972: cc_value gl_code_combinations.segment1%TYPE;
973: begin
974:
975: retcode := 0;
976: h_book := book;