接收事务处理代码,OracleEBS代码库,德仔网

代码语言
代码分类
【OracleEBS】接收事务处理
作者:专注Oracle EBS / 发布于2012/11/29/ 807
/*--------------------------//接收事务处理------------------------************/
select * from RCV_TRANSACTIONS_V
select * from RCV_TRANSACTIONS_INTERFACE
select * from MTL_TRANSACTION_LOTS_TEMP
select * from MTL_SERIAL_NUMBERS_TEMP ----------条码-----------
select * from QA_RESULTS_V

select * from ic_lots_mst
select * from mtl_serial_numbers ----------条码表-----------
select * from wms_license_plate_numbers
select * from rcv_lots_supply
select * from oe_lot_serial_numbers ----------销售订单批次条码---------------
select * from rcv_transactions -----//接收事务处理----
select * from sy_reas_cds 
select * from mtl_serial_numbers_all_v
select * from qa_plan_char_value_lookups
select * from mtl_lot_numbers
select * from mtl_serial_numbers-------------序列号
select * from wip_operations_all_v
select * from cs_counter_values
select * from wip_discrete_jobs_all_v
select * from cs_incidents
select * from qa_ahl_mr
select * from cs_counters
select * from qa_csi_item_instances
select * from mtl_system_items_kfv
select * from wms_lpn_contents
select * from ic_item_mst
select * from ic_tran_pnd
select * from ic_loct_inv
select * from ic_loct_mst
select * from hr_employees------------人事人员
select * from pjm_projects_all_v
select * from PA_TASKS_EXPEND_V
select * from wip_osp_jobs_val_v
select * from mtl_kanban_cards
select * from hr_locations_all --------人事组织档案-----
select * from hr_locations_all_tl -------同上
select * from mtl_serial_numbers_all_v ---------序列视图
select * from hz_parties----------
select * from po_pos_val_v 
select * from rcv_transactions_interface
select * from PO_LINE_LOCATIONS
select * from PO_REQUISITION_LINES 
select * from wip_discrete_jobs_all_v 
select * from oke_k_headers_lov_v 
select * from oke_k_lines_full_v 
select * from oke_k_deliverables_vl 
select * from OE_SOLD_TO_ORGS_V ------------
select * from cst_cost_groups --------
select * from rcv_shipment_headers ----------发运头
select * from rcv_shipment_lines --------发运体
select * from rcv_transactions_interface

select * from oe_order_lines_all -----------订单
select * from oe_order_headers_all ---------订单
select * from oe_transaction_types_all ------订单处理\交易类型
select * from MTL_TRANSACTION_TYPES-------交易的类型--
select * from oe_transaction_types_tl -------订单处理类型

select * from rcv_transactions ------接收事务处理
select * from rcv_supply -----------
select * from oe_transaction_types
select * from oe_po_enter_receipts_v 
select * from mtl_customer_items_all_v 
select * from mtl_lot_issues_val_v ------------
select * from mtl_uom_conversions -----------
select * from mtl_uom_class_conversions --------------
select * from po_lines_supplier_items_v 
select * from per_all_people_f ---------------
select * from financials_system_parameters 
select * from org_freight ------运输组织--------
select * from mtl_supply -------------物料供给
select * from org_organization_definitions --------------库存组织定义
select * from po_vendor_sites 
select * from rcv_sources_both_val_v ----------------
select * from rcv_suppliers_val_v -----------
select * from hr_locations_all ---------
select * from hr_locations_all_tl ------------
select * from mtl_item_revisions -----------
select * from mtl_system_items_kfv ----正规ID编码，------
select * from po_requisition_lines 
select * from financials_system_parameters 
select * from po_lookup_codes ----------------
select * from po_requisition_headers 
select * from rcv_shipment_lines---------
select * from rcv_transactions------------
select * from po_line_locations 
select * from hr_locations_all_tl -----------
select * from po_releases 
select * from po_pos_all_v 
select * from po_pos_val_v 
select * from per_all_people_f ------------
select * from rcv_transactions_interface

select * from mtl_serial_numbers ------------------SERIAL----------
select * from mtl_transaction_lots_temp 
select * from mtl_employees_view ----------
select * from po_suppliers_val_v ---------------
select * from mtl_employees_current_view -------------
select * from mtl_item_status -------------------物料项状态基础表---------
select * from org_organization_definitions ------------
select * from mtl_secondary_inventories -----子库存组织---------
select * from mtl_transaction_types ------------
select * from mtl_txn_source_types -----------
select * from mtl_system_items_vl ------------
select * from mtl_system_items_kfv --------
select * from mtl_category_sets_vl ---------
select * from mtl_physical_inventories_v ----------
select * from mtl_kanban_cards 
select * from mtl_item_sub_inventories 
select * from fnd_folders -------
select * from fnd_user --------系统用户
select * from so_order_types_all ----------销售订单类型
select * from oe_order_headers_all ---------
select * from qa_customers_lov_v ---------
select * from qa_sales_orders_lov_v-----------
select * from PO_VENDORS -----采购供货方-----
select * from po_shipments_all_v 
select * from po_lines_val_v 
select * from po_pos_val_v 
select * from mtl_task_v 
select * from pjm_projects_all_v 
select * from qa_customers_lov_v ---
select * from mtl_item_revisions ----
select * from mtl_category_sets----
select * from wip_operations_all_v 
select * from wip_first_open_schedule_v 
select * from wip_discrete_jobs_all_v 
select * from wip_lines_val_v 
select * from mtl_item_uoms_view -----
select * from bom_resources_val_v 
select * from bom_departments_val_v 
select * from qa_plan_char_value_lookups ---------
select * from qa_plans-------
select * from qa_specs_v 
select * from qa_specs_val_v 
select * from po_lookup_codes -----
select * from hr_employees_current_v --------
select * from po_quality_codes 
select * from mtl_transaction_reasons --库存相关接转信息----
select * from mtl_uom_conversions_val_v ----
select * from mtl_uom_class_conversions ----
select * from hr_locations_all --------
select * from hr_locations_all_tl --------
select * from hz_locations -------
select * from hz_party_sites ---------
select * from hz_cust_site_uses_all --------
select * from hz_cust_acct_sites_all ---------
select * from hz_cust_accounts -----------
select * from oe_order_lines_all -----------
select * from oe_drop_ship_sources 
select * from rcv_trx_int_lots_v 
select * from mtl_rma_serial_temp 
select * from rcv_trx_int_serials_v 
select * from po_distributions 
select * from pjm_projects_all_v 
select * from po_distributions 
select * from hr_locations_all_tl-----------
select * from hr_employees_current_v -------
select * from po_lookup_codes -----------
select * from pjm_projects_all_v 
select * from pa_tasks_expend_v 
select * from mtl_kanban_cards 
select * from qa_plans_val_v ---------
试试其它关键字
　接收事务处理　
同语言下
可能有用的
专注Oracle EBS贡献的其它代码(66)