DBA Data[Home] [Help]

APPS.FARX_AJ dependencies on GL_CODE_COMBINATIONS

Line 133: GL_CODE_COMBINATIONS DHCC,

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

Line 463: gl_code_combinations glcc_ar,

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,

Line 519: gl_code_combinations glcc_ar,

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,

Line 575: gl_code_combinations glcc_ar,

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,

Line 646: gl_code_combinations glcc_fa,

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,

Line 647: gl_code_combinations glcc_ar,

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,

Line 714: gl_code_combinations glcc_fa,

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,

Line 715: gl_code_combinations glcc_ar,

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

Line 802: gl_code_combinations glcc_fa,

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,

Line 803: gl_code_combinations glcc_ar,

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,

Line 889: gl_code_combinations glcc_fa,

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,

Line 890: gl_code_combinations glcc_ar,

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,

Line 972: cc_value gl_code_combinations.segment1%TYPE;

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;