Wednesday, August 29, 2018

Inventory Tables in Oracle APPS

mtl_system_items_tl
mtl_onhand_quantities_detail
mtl_transaction_accounts
mtl_material_transactions_temp
mtl_material_transactions
mtl_consigned_diag_errors
mtl_transaction_flow_headers
mtl_transaction_flow_lines
mtl_pac_act_cst_dtl_temp
mtl_eres_transactions_gtmp
mtl_onhand_quantities_d_bkp
mtl_onhand_discrepancies
inv_mvt_excep_rep_temp
mtl_onhand_lock_temp
mtl_rma_serial_temp
mtl_vmi_quantities_temp
inv_eres_events_temp
inv_msn_gtemp
mtl_allocations_gtmp
mtl_consigned_diag_temp
mtl_system_items_b
mtl_uom_conversions
mtl_reservations
mtl_interorg_ship_methods
mtl_transaction_types
mtl_item_locations
mtl_item_categories
mtl_eam_asset_activities
mtl_serial_numbers
mtl_units_of_measure_tl
mtl_related_items_pln_info
mtl_physical_adjustments
mtl_related_items_cust_ref
org_freight_tl
mtl_item_templates
mtl_interorg_parameters
mtl_uom_conversions_a
mtl_parameters
mtl_eam_asset_attr_values
mtl_cross_references
mtl_cst_actual_cost_details
mtl_cst_txn_cost_details
mtl_demand_interface
mtl_categories_b
mtl_txn_source_types
mtl_mfg_part_numbers
mtl_item_attributes
mtl_descr_element_values
mtl_secondary_inventories
mtl_material_statuses_b
mtl_mvt_stats_rule_sets_tl
mtl_status_transaction_control
mtl_item_status
mtl_txn_request_lines
mtl_transaction_lots_temp
mtl_transaction_reasons
mtl_mgd_inventory_positions
mtl_demand
mtl_txn_request_headers
mtl_movement_statistics
mtl_descriptive_elements
mtl_related_items
mtl_rtg_item_revisions
mtl_item_revisions_b
mtl_cross_reference_types
mtl_status_attribute_values
mtl_manufacturers
mtl_movement_parameters
mtl_uom_class_conversions
mtl_forecast_rules
mtl_lot_numbers
org_acct_periods
mtl_planners
mtl_abc_assgn_group_classes
mtl_abc_assignments
mtl_abc_assignment_groups
mtl_abc_classes
mtl_customer_item_xrefs
mtl_cycle_count_headers
mtl_cycle_count_entries
mtl_cycle_count_classes
mtl_cycle_count_items
mtl_pending_item_status
mtl_generic_dispositions
mtl_atp_rules
org_gl_batches
mtl_replenish_lines
mtl_kanban_cards
mtl_kanban_card_activity
mtl_kanban_pull_sequences
mtl_transaction_lot_numbers
mtl_physical_inventories
mtl_physical_inventory_tags
mtl_unit_transactions
mtl_replenish_headers
mtl_supply
mtl_category_sets_b
mtl_item_sub_inventories
mtl_transactions_interface
mtl_sales_orders
mtl_default_category_sets
org_access
mtl_commodity_codes
mtl_material_txn_allocations
mtl_category_sets_tl
mtl_uom_classes_tl
mtl_customer_items
mtl_serial_numbers_temp
mtl_so_rma_interface
mtl_abc_compile_headers
mtl_cc_subinventories
mtl_sys_items_sn
mtl_attr_appl_dependencies
mtl_item_catalog_groups_b
mtl_bis_inv_by_period
mtl_economic_zones_b
mtl_safety_stocks
mtl_supply_demand_temp
mtl_oh_qtys_sn
mtl_supply_sn
mtl_cc_entries_interface
mtl_cc_schedule_requests
mtl_eam_network_assets
mtl_intercompany_parameters
mtl_reservations_interface
mtl_short_chk_param
mtl_categories_tl
mtl_item_catalog_groups_tl
mtl_secondary_locators
mtl_category_set_valid_cats
mtl_country_assignments
mtl_category_accounts
mtl_eam_asset_attr_groups
mtl_demand_sn
mtl_material_statuses_tl
mtl_picking_rules
mtl_demand_histories
mtl_txn_cost_det_interface
mtl_stat_type_usages
mtl_cc_serial_numbers
wms_cartonization_temp
cost_upgr_error_table
inv_item_temp
inv_min_max_temp
je_it_inv_packslips
je_it_stk_valuation
mlog$_mtl_default_category
mlog$_mtl_demand
mlog$_mtl_material_transac
mlog$_mtl_reservations
mlog$_mtl_supply
mlog$_mtl_txn_request_head
mlog$_mtl_user_demand
mlog$_mtl_user_supply
mtl_abc_compiles
mtl_abc_compiles_efc
mtl_abc_compile_headers_efc
mtl_actual_cost_subelement
mtl_actual_cost_subelement_efc
mtl_catalog_search_items
mtl_cc_interface_errors
mtl_cc_sched_count_xrefs
mtl_ci_interface
mtl_ci_xrefs_interface
mtl_consigned_qty_temp
mtl_consumption_definition
mtl_consumption_transactions
mtl_consumption_txn_temp
mtl_copy_org_interface
mtl_copy_org_report
mtl_copy_org_report_temp
mtl_copy_org_temp
mtl_cross_references_interface
mtl_cst_actual_cost_detail_efc
mtl_cst_layer_act_cost_details
mtl_cst_txn_cost_details_efc
mtl_cycle_count_classes_efc
mtl_cycle_count_entries_efc
mtl_cycle_count_headers_efc
mtl_desc_elem_val_interface
mtl_do_check_temp
mtl_eam_asset_num_interface
mtl_eam_asset_search_temp
mtl_eam_attr_val_interface
mtl_eam_locations
mtl_economic_zones_tl
mtl_ext_objects
mtl_fiscal_cat_accounts
mtl_flex_context
mtl_icg_aliases
mtl_icg_categories
mtl_interface_errors
mtl_interface_proc_controls
mtl_onhand_quantity_temp
mtl_org_report_temp
mtl_pac_actual_cost_details
mtl_pac_actual_cost_detail_efc
mtl_pac_cost_subelements
mtl_pac_cost_subelements_efc
mtl_pac_txn_cost_details
mtl_pac_txn_cost_details_efc
mtl_period_cg_summary
mtl_period_summary
mtl_serial_numbers_clup
mtl_item_attributes_temp
mtl_item_categories_interface
mtl_item_child_info_interface
mtl_item_loc_defaults
mtl_item_revisions_interface
mtl_item_revisions_tl
mtl_item_sub_defaults
mtl_item_sub_invs_interface
mtl_item_templ_attributes
mtl_item_values_temp
mtl_kanban_card_print_temp
mtl_kanban_templates
mtl_le_economic_zones
mtl_lot_numbers_clup
mtl_material_status_history
mtl_material_transactions_efc
mtl_mobile_login_hist
mtl_movement_statistics_efc
mtl_mtrx_tmp_sn
mtl_mvt_stats_rule
mtl_mvt_stats_rules
mtl_mvt_stats_rule_sets_b
mtl_object_events
mtl_object_genealogy
mtl_object_genealogy_interface
mtl_onhand_quantities_backup
mtl_serial_numbers_interface
mtl_serial_num_intc_clup
mtl_serial_num_temp_clup
mtl_short_chk_statements
mtl_short_chk_temp
mtl_so_rma_receipts
mtl_summary_temp
mtl_system_items_b_efc
mtl_system_items_interface
mtl_transaction_accounts_efc
mtl_transaction_lots_infc_clup
mtl_transaction_lots_interface
mtl_transaction_lots_temp_clup
mtl_transaction_lot_num_clup
mtl_transfer_temp
mtl_unit_txns_clup
mtl_update_records_temp
mtl_user_demand
mtl_user_supply
mtl_u_demand_sn
mtl_u_supply_sn
rsv_temp
mtl_period_summary_efc
mtl_per_close_dtls
mtl_per_close_dtls_efc
mtl_physical_adjustments_efc
mtl_physical_inventories_efc
mtl_physical_subinventories
mtl_purge_header
mtl_qoh_item_tmp
mtl_qoh_locator_tmp
mtl_qoh_lot_tmp
mtl_qoh_rev_tmp
mtl_qoh_sub_tmp
mtl_related_items_interface
mtl_replenish_headers_int
mtl_replenish_lines_int
mtl_reservations_sn
mtl_rsv_quantities_temp
mtl_rtg_item_revs_interface
mtl_seasonality_indices
mtl_secondary_locs_interface

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...