To search tables, views of table name:
- Tab
Customer Order table:
- oe_order_headers_all
- oe_order_lines_all
- oe_order_distributions_all
- oe_transaction_types_tl
- oe_transaction_types_vl
Purchase order tables:
- po_headers_all
- po_lines_all
- po_distributions_all
- po_line_locations_all
- po_release_all
- po_vendors
- po_vendor_sites_all
Requisitions table:
- po_requisition_headers_all
- po_requisition_lines_all
- po_req_distributions_all
PO interface tables:
- po_headers_interface
- po_distributions_interface
- po_lines_interface
- po_interface_errors
- po_requisitions_interface_all
- po_req_dist_interface_all
Blanket Table:
- oe_blanket_headers_all
- oe_blanket_lines_all
- oe_blanket_headers_ext
- oe_blanket_lines_ext
Quotes Tables:
- aso_quote_headers_all
- aso_quote_lines_all
- aso_quote_statuses_b
- aso_quote_statuses_tl
- as_leads_all
- aso_pvt_quote_headers_ui_v
- aso_pvt_quote_lines_ui_v
- aso_shipments
- aso_payments
Delivery Tables:
- wsh_delivery_assignments
- wsh_delivery_details
- wsh_new_deliveries
Item Tables:
- mtl_system_items_b
- mtl_item_status
- mtl_parameters
- mtl_item_categories
- mtl_categories_b
- mtl_reservations_v
- mtl_item_locations
- mtl_material_transactions_temp
- mtl_units_of_measure_tl
- mtl_demand
- mtl_secondary_inventories
- mtl_onhand_quantities
- mtl_transaction_types
Organization Tables:
- org_organization_definitions
- hr_locations_v
- hr_organization_units
Price list Tables:
- qp_list_headers
- qp_list_headers_tl
- qp_list_lines
- qp_list_lines_v
- qp_pricing_attributes
HR Tables:
- Hr_operating_units
- Hr_locations_v
- hr_locations
- Hr_all_organization_unit
Salesrep Table:
- ra_salesreps_all
- ar_lookups
- ar_collectors
- jtf_rs_salesreps
- jtf_rs_defresources_v
- jtf_rs_resource_extns
Supplier Table:
- ap_suppliers
- ap_supplier_sites_all
- ap_supplier_contact
TCA Tables:
- hz_parties
- hz_party_sites
- hz_locations
- hz_cust_accounts
- hz_cust_acct_sites_all
- hz_cust_site_uses_all
- hz_relationships
- hz_party_relationships
- hz_customer_profile
- hz_cust_profile_class
- hz_cust_account_roles
- hz_contact_points
- hz_organization_profiles
FND Tables:
- fnd_tables
- fnd_views
- fnd_lookup_values
- fnd_user
- fnd_responsibility
- fnd_responsibility_tl
- fnd_concurrent_ programs
- fnd_concurrent_programs_tl
- fnd_request_sets
- fnd_request_groups
- fnd_profile_options
- fnd_profile_option_values
- fnd_new_messages
- fnd_application
- fnd_flex_values
- Fnd_flex_values_tl
- Fnd_flex_values_vl
- fnd_flex_value_sets
- fnd_menus
- fnd_menus_tl
- fnd_territories
OTM Tables:
- otm_allocation
- otm_allocation_base
- otm_driver
- otm_driver_assignment
- otm_item
- otm_location
- otm_location_refnum
- otm_order_movement
- otm_order_movement_refnum
- otm_order_movement_status
- otm_order_release
- otm_order_release_refnum
- otm_shipment
- otm_shipment_refnum
- otm_shipment_status
- otm_shipment_stop
- otm_shipment_stop_d
- otm_ship_unit
- otm_s_ship_unit
- otm_s_ship_unit_line
No comments:
Post a Comment