Wednesday, August 29, 2018

GL Tables in Oracle APPS

gl_daily_post_int2
gl_budget_interim
gl_translation_interim
gl_xlate_posting_interim
gl_sets_of_books
gl_periods
gl_code_combinations
gl_daily_conversion_types
gl_encumbrance_types
gl_budget_versions
jg_zz_ta_rule_sets
jg_zz_ta_rule_lines
jg_zz_ta_cc_ranges
jg_zz_ta_account_ranges
gl_je_lines
gl_je_categories_tl
gl_period_types
gl_period_statuses
gl_transaction_calendar
gl_period_sets
gl_recurring_batches
gl_budget_period_ranges
gl_summary_templates
gl_je_sources_tl
gl_je_headers
gl_balances
gl_budget_entities
gl_account_hierarchies
gl_elimination_sets
gl_iea_subsidiaries
gl_daily_rates
gl_stat_account_uom
gl_budgets
gl_cons_segment_map
gl_date_period_map
gl_import_references
jg_zz_ta_allocated_lines
gl_mc_reporting_options
gl_je_batches
gl_translation_rates
gl_translation_tracking
gl_ussgl_transaction_codes
gl_cons_flex_hierarchies
gl_consolidation
gl_weighted_avg_details
gl_interface

gl_balances_delta_interim
gl_cross_rate_temp
gl_cross_rate_rules
gl_cross_rate_rule_dtls
gl_iea_transactions
gl_iea_transaction_types
gl_iea_recur_transactions
gl_iea_clearing_accounts
gl_consolidation_audit
gl_cons_flexfield_map
gl_cons_set_assignments
gl_consolidation_sets
gl_alloc_formulas
gl_automatic_posting_options
gl_alloc_batches
gl_iea_segment_map
gl_auto_alloc_bat_hist_det
gl_auto_alloc_sets
gl_mc_book_assignments
gl_revaluations
gl_reval_account_ranges
gl_suspense_accounts
je_be_vat_rep_rules
gl_autoreverse_options
gl_intercompany_acc_sets
gl_oasis_summary_data
gl_bc_packets
gl_bc_option_details
gl_iea_autogen_map
gl_auto_alloc_set_history
gl_entity_budgets
gl_row_multipliers
gl_recurring_headers
gl_historical_rates
gl_auto_alloc_batch_history
gl_authorization_limits
gl_budget_batches
ap_mc_invoices_tmp
gl_alloc_int_1_2618275
gl_alloc_int_1_2618555
gl_alloc_int_1_2618750
gl_alloc_int_1_2618752
gl_alloc_int_1_2618780
gl_alloc_int_1_2618783
gl_alloc_int_1_2618798
gl_alloc_int_1_2618809
gl_alloc_int_1_2618846
gl_alloc_int_1_2618906
gl_alloc_int_1_2618940
gl_alloc_int_1_2618941
gl_alloc_int_1_2622147
gl_alloc_int_1_2626340
gl_alloc_int_1_2626368
gl_alloc_int_1_2627515
gl_alloc_int_1_2627516
gl_alloc_int_1_2627517
gl_alloc_int_1_2627518
gl_alloc_int_1_2627531
gl_alloc_int_1_2627533
gl_alloc_int_1_2632882
gl_alloc_int_1_2633706
gl_alloc_int_2_2618275
gl_alloc_int_2_2618750
gl_alloc_int_2_2618752
gl_alloc_int_2_2618780
gl_alloc_int_2_2618783
gl_alloc_int_2_2618798
gl_alloc_int_2_2618809
gl_alloc_int_2_2618846
gl_alloc_int_2_2618906
gl_alloc_int_2_2618940
gl_alloc_int_2_2618941
gl_alloc_int_2_2622147
gl_alloc_int_2_2626340
gl_alloc_int_2_2626368
gl_alloc_int_2_2627515
gl_alloc_int_2_2627516
gl_alloc_int_2_2627517
gl_alloc_int_2_2627518
gl_alloc_int_2_2627531
gl_alloc_int_2_2627533
gl_alloc_int_2_2632882
gl_alloc_int_2_2633706
gl_alloc_int_3_2618275
gl_alloc_int_3_2618750
gl_alloc_int_3_2618752
gl_alloc_int_3_2618780
gl_alloc_int_3_2618783
gl_alloc_int_3_2618798
gl_alloc_int_3_2618809
gl_alloc_int_3_2618846
gl_alloc_int_3_2618906
gl_alloc_int_3_2618940
gl_alloc_int_3_2618941
gl_alloc_int_3_2622147
gl_alloc_int_3_2626340
gl_alloc_int_3_2626368
gl_alloc_int_3_2627515
gl_alloc_int_3_2627516
gl_alloc_int_3_2627517
gl_alloc_int_3_2627518
gl_alloc_int_3_2627531
gl_alloc_int_3_2627533
gl_alloc_int_3_2632882
gl_alloc_int_3_2633706
gl_alloc_segvals_int
gl_alloc_target_2618275
gl_alloc_target_2618750
gl_alloc_target_2618752
gl_alloc_target_2618780
gl_alloc_target_2618783
gl_alloc_target_2618798
gl_alloc_target_2618809
gl_alloc_target_2618846
gl_alloc_target_2618906
gl_alloc_target_2618940
gl_alloc_target_2618941
gl_alloc_target_2622147
gl_alloc_target_2626340
gl_alloc_target_2626368
gl_alloc_target_2627515
gl_alloc_target_2627516
gl_alloc_target_2627517
gl_alloc_target_2627518
gl_alloc_target_2627531
gl_alloc_target_2627533
gl_alloc_target_2632882
gl_alloc_target_2633706
gl_ahe_detail_ranges_gt
gl_alloc_formula_lines
gl_alloc_history
gl_application_groups
gl_archive_balances
gl_archive_batches
gl_archive_daily_balances
gl_archive_headers
gl_archive_history
gl_archive_lines
gl_archive_references
gl_automatic_posting_sets
gl_auto_alloc_batches
gl_auto_alloc_rev_batches
gl_balances_delta
gl_budget_assignments
gl_budget_assignment_ranges
gl_budget_frozen_ranges
gl_budget_interface
gl_budget_range_interim
gl_budget_types
gl_carryforward_ranges
gl_bc_dual
gl_bc_dual2
gl_bc_event_timestamps
gl_bc_options
gl_bc_packet_arrival_order
gl_bc_period_map
gl_bis_segval_int
gl_cons_interface_24407
gl_daily_balances
gl_daily_conversion_rates_r10
gl_daily_open_int
gl_daily_rates_interface
gl_doc_sequence_audit
gl_dynamic_summ_combinations
gl_efc_budget_mapping
gl_efc_changed_trx
gl_efc_data_utility
gl_efc_disabled_triggers
gl_efc_run_history
gl_elimination_history
gl_concurrency_control
gl_concurrent_schedules
gl_consolidation_accounts
gl_consolidation_history
gl_cons_batches
gl_cons_interface_24401
gl_cons_interface_24406
gl_elimination_journals
gl_elim_accounts_map
gl_elim_bal_options
gl_extract_history
gl_historical_rate_ranges
gl_iea_import_registry
gl_iea_interface
gl_iea_recur_batches
gl_iea_recur_history
gl_iea_recur_lines
gl_iea_segment_rule_map
gl_iea_transaction_lines
gl_interface_control
gl_intercompany_accounts
gl_interco_accounts_r110
gl_interco_bsv_int_24656
gl_interco_bsv_int_24659
gl_interco_bsv_int_24884
gl_interco_bsv_int_24936
gl_interco_bsv_int_25002
gl_interco_bsv_int_25184
gl_interco_bsv_int_25355
gl_interco_bsv_int_25356
gl_interco_bsv_int_26078
gl_interco_bsv_int_26081
gl_interco_bsv_int_26127
gl_interco_bsv_int_26184
gl_interco_bsv_int_26212
gl_interco_bsv_int_26214
gl_interco_bsv_int_26420
gl_interco_bsv_int_26481
gl_interco_bsv_int_26547
gl_interco_bsv_int_26666
gl_interco_bsv_int_26681
gl_interco_bsv_int_26774
gl_interco_bsv_int_26978
gl_interco_bsv_int_27022
gl_interco_bsv_int_27060
gl_interco_bsv_int_27180
gl_interco_bsv_int_27263
gl_interco_bsv_int_27422
gl_interco_bsv_int_27486
gl_interco_bsv_int_27564
gl_interco_bsv_int_27663
gl_interco_bsv_int_27729
gl_interco_bsv_int_27912
gl_interco_bsv_int_27994
gl_interco_bsv_int_28030
gl_interco_bsv_int_28102
gl_interco_bsv_int_28178
gl_interco_bsv_int_28346
gl_interco_bsv_int_28424
gl_interco_bsv_int_28692
gl_interco_bsv_int_28756
gl_interco_bsv_int_29006
gl_interco_bsv_int_29092
gl_interco_bsv_int_29229
gl_interco_bsv_int_29265
gl_interco_bsv_int_29307
gl_interco_bsv_int_29372
gl_interco_bsv_int_29650
gl_interco_bsv_int_29740
gl_interco_bsv_int_29882
gl_interco_bsv_int_30002
gl_interco_bsv_int_30062
gl_interco_bsv_int_30518
gl_interco_bsv_int_30539
gl_interco_bsv_int_30671
gl_interco_bsv_int_30724
gl_interco_bsv_int_30728
gl_interco_bsv_int_30732
gl_interco_bsv_int_30734
gl_interco_bsv_int_30738
gl_interco_bsv_int_30798
gl_interco_bsv_int_30952
gl_interco_bsv_int_31022
gl_interco_bsv_int_31073
gl_interco_bsv_int_31074
gl_interco_lines_int_30724
gl_interco_lines_int_30728
gl_interco_lines_int_30732
gl_interco_lines_int_30734
gl_interco_lines_int_30738
gl_interco_lines_int_30798
gl_interco_lines_int_30952
gl_interco_lines_int_31022
gl_interco_lines_int_31073
gl_interco_lines_int_31074
gl_interface_history
gl_je_inclusion_rules
gl_journal_reports_itf
gl_lookups_old
gl_mc_conversion_rules
gl_mc_conv_int_30717
gl_mc_conv_int_30719
gl_mc_conv_int_30721
gl_mc_conv_int_30724
gl_mc_conv_int_30730
gl_mc_conv_int_30732
gl_mc_conv_int_30734
gl_mc_conv_int_30736
gl_mc_conv_int_30738
gl_mc_conv_int_30794
gl_mc_conv_int_30852
gl_mc_conv_int_30932
gl_mc_conv_int_31018
gl_mc_conv_int_31058
gl_mc_conv_int_31060
gl_mc_conv_int_31061
gl_mc_conv_int_31069
gl_mc_conv_int_31070
gl_mc_conv_int_31085
gl_mc_conv_int_31122
gl_mc_options_int_30717
gl_mc_options_int_30719
gl_mc_options_int_30721
gl_mc_options_int_30724
gl_mc_options_int_30730
gl_mc_options_int_30732
gl_mc_options_int_30734
gl_mc_options_int_30736
gl_mc_options_int_30738
gl_mc_options_int_30794
gl_mc_options_int_30852
gl_mc_options_int_30932
gl_mc_options_int_31018
gl_mc_options_int_31058
gl_mc_options_int_31060
gl_mc_options_int_31061
gl_mc_options_int_31069
gl_mc_options_int_31070
gl_mc_options_int_31085
gl_mc_options_int_31122
gl_mc_upgrade_history
gl_mc_upgrade_rates
gl_movemerge_accounts
gl_movemerge_bal_103
gl_movemerge_bal_104
gl_movemerge_bal_123
gl_movemerge_bal_143
gl_movemerge_bal_164
gl_movemerge_bal_184
gl_movemerge_bal_63
gl_movemerge_bal_83
gl_movemerge_bal_84
gl_movemerge_interim_103
gl_movemerge_interim_104
gl_movemerge_interim_123
gl_movemerge_interim_143
gl_movemerge_interim_164
gl_movemerge_interim_184
gl_movemerge_interim_63
gl_movemerge_interim_83
gl_movemerge_interim_84
gl_movemerge_requests
gl_net_income_accounts
gl_oasis_collection_int
gl_oasis_fin_assignments
gl_oasis_fin_items
gl_oasis_fin_metrics
gl_open_interim
gl_posting_interim
gl_posting_interim_24331
gl_posting_interim_24656
gl_posting_interim_30716
gl_recurring_lines
gl_recurring_line_calc_rules
gl_revaluation
gl_revaluation_accounts
gl_reval_chd_ranges_gt
gl_reval_exp_ranges_gt
gl_rollup_group_scores
gl_rx_trial_balance_itf
gl_segment_frequencies
gl_segval_inherit_history
gl_shares_activity
gl_shares_outstanding
gl_storage_parameters
gl_summary_hierarchies
gl_summary_hierarchy_int
gl_system_setup
gl_system_usages
gl_tax_options
gl_tax_option_accounts
gl_temporary_combinations
gl_transaction_dates
gl_transaction_rate_exceptions
gl_translation_statuses
gl_ussgl_account_pairs
gl_year_end_acct_int_1
gl_year_end_acct_int_8
gl_year_end_bal_int_1
gl_year_end_bal_int_8
je_be_annual_vat
je_be_esl_summaries
je_be_line_type_map
je_be_logs
je_be_reporters
je_be_vat_allocations
je_be_vat_alloc_errors
je_doc_sequence_audit
je_gr_cutoff_rules
je_gr_je_header_sequence
je_it_report_parameters
je_it_tmp_rpt_headers

No comments:

Post a Comment

Query To Fetch AP Invoice Details From SO Number(Doc ID 2949013.1)

SELECT dh.source_order_number       ,df.source_line_number as so_line_number   ,df.fulfill_line_number    ,ddr.doc_user_key as po_number...