查看: 4002|回复: 6
什么叫RMA退货，业务场景是什么样的？
论坛徽章:2
小弟现在工作接触到RMA退货，手上没有些资料对其介绍，没有一个概念，向各位大是们请教下，谢谢。
问题：什么叫RMA退货，业务场景是什么样的？
论坛徽章:425
退貨給供應商
论坛徽章:1
当销售订单已做了发运确认,这时要退货,就要增加一行或一张退货行/单,在库存操作退货时就要用到RMA退货,增加的退货行就是RMA编号.
论坛徽章:15
你看看这个了。
论坛徽章:15
最近看ERP资料。看到很多RMA，不仔细看还真以为是RMB呢。找了找资料。原来RMA是退货之类的咚咚。找到了一个比较详细的，记录下来。：
关于RMA（ 退货）的业务流程
rma在业务上有三种处理方式：repair退回修理、replace退换、return退回。一般都要求退到暂存仓，进行检验。
1。repair ： 可能会参与新的mrp运算；然后通过维修工单生产、入库、出货。财务上会新开一张贷项凭单、收费或不收费发票。与原发票冲抵。
2。replace：相当与新增加一张订单，需要进入mrp运算，然后按照正常流程生产、出货。退回物料则在检验后可选择入库、维修或报废。财务上也会新开一张贷项凭单、收费或不收费发票。与原发票冲抵。
3。return：物料入库；财务上开一张贷项凭单，冲抵发票。
刚才又看了一个资料，感觉这个解释的也不错：
RMA是Return Material Authorization的英文缩写，即退料审查。是处理用户不良产品退货、换货的主要流程。当用户所使用某产品或部件不能正常工作时，将发起一个 RMA流程，首先用户必须填写RMA申请单，然后RMA的处理人员将对该RMA申请进行审查，例如是否在保修期内等，然后分配一个RMA号给该申请单。并 有3种处理方式，一种是换货，通知用户寄回RMA件，确认收到后寄出新的产品或部件（有时，也可能先寄出新货品），同时寄出发票（有金额或无金额，红字发 票冲账，新开发票按再销售处理），新品发货走正常订单处理流程，退回的RMA件做入库处理；第二种方式是退货，退回货物后付钱或增加信用余额，同时走红字 发票冲账。第三种方式是维修，收到RMA件入库后，开出维修通知单或服务通知单，在维修完成、服务确认后，发货或用户取货时，再做收款和财务处理。
RMA从财务的角度过程清晰，计算简单。从品质管理的角度，处理速度块，客户满意度高。在企业中，有时还要走对供应商的RMA处理，只是过程刚好相反。
论坛徽章:2
谢谢楼上对本贴的积极回复。
特别是5楼这位仁兄，介绍得非常详细，小弟终于明白了，非常感谢。
论坛徽章:4
itpub.net All Right Reserved. 北京盛拓优讯信息技术有限公司版权所有　　　　
　北京市公安局海淀分局网监中心备案编号：10　广播电视节目制作经营许可证：编号（京）字第1149号标准展BOM存储过程bompexpl.exploder_userexit 和临时表bom_explosion_temp...
Oracle 自定义字符串转换数组的函数...
如何设置USERENV('CLIENT_INFO')的值...
Oracle EBS AR 事务处理API开发...
Oracle EBS 客制键弹性域编译失败...
AR事务处理“贷项通知单”接口API。...
修改完采购订单明细以后，需求要审批。经查调用代码如下:
ActionOriginatedFrom
varchar2(30) := 'PO_FORM';
DocumentID
Number := 63556;
DocumentNumber
Varchar2(30) := '';
PreparerI...
Oracle Form 关于ORA-04062: signature(属package&XXXXXXXXX&)已经被更改 解决方法...
Oracle EBS OM 销售订单释放暂挂API代码...
如何设置事务处理分配行金额、采购单价、成本和资源费率等等数字小数点位数？...
访问：370628次
积分：4583
积分：4583
排名：第7141名
原创：108篇
评论：60条
(1)(2)(1)(2)(1)(1)(2)(4)(1)(1)(1)(2)(1)(1)(4)(4)(1)(2)(2)(1)(11)(6)(4)(5)(1)(1)(1)(1)(2)(1)(1)(1)(4)(3)(4)(2)(1)(1)(2)(2)(3)(1)(2)(7)(1)(3)(1)(2)(2)
(window.slotbydup = window.slotbydup || []).push({
id: '4740887',
container: s,
size: '250,250',
display: 'inlay-fix'ORACLE EBS常用表 - NewProgramer - 博客园
call fnd_global.APPS_INITIALIZE(,401)
select fnd_profile.VALUE('ORG_ID') FROM DUAL
select * from hr_operating_units hou where hou.organization_id=204
select * from fnd_application&&&
select * from fnd_application_tl where application_id=101
select * from fnd_application_vl where application_id = 101
select * from fnd_flex_value_sets&&&
select * from fnd_flex_values&&&&&&&
select * from fnd_flex_values_vl
----弹性域
select * from fnd_id_flexs&&&&&&&&&
select * from fnd_id_flex_structures where id_flex_code='GL#'
select * from fnd_id_flex_segments where id_flex_code='GL#' and id_flex_num=50671
select * from fnd_profile_options_vl
select * from fnd_concurrent_programs&&& 程序表
select * from fnd_concurrent_requests&&& 请求表
select * from fnd_concurrent_processes&& 进程表
select * from org_organization_definitions&& 库存组织
select * from mtl_parameters&&&&&&&&&&&&&&&& 组织参数
select * from mtl_system_items_b where inventory_item_id = 171 and organization_id=204 物料表
select * from mtl_secondary_inventories&&& 子库存
select * from mtl_item_locations&&&&&&&&&& 货位
select * from mtl_lot_numbers&&&&&&&&&&&&& 批次
select * from mtl_onhand_quantities&&&&&&& 现有量表
select * from mtl_serial_numbers&&&&&&&&&& 序列
select * from mtl_material_transactions&&& 物料事务记录
select * from mtl_transaction_accounts&&&& 会计分录
select * from mtl_transaction_types&&&&&&& 事务类型
select * from mtl_txn_source_types&&&&&&&& 事务来源类型
select * from mfg_lookups ml where ml.LOOKUP_TYPE = 'MTL_TRANSACTION_ACTION'
select * from po_requisition_headers_all&& 请求头
select * from po_requisition_lines_all&&&& 请求行
select * from po_headers_all&&&&&&&&&&&&&& 订单头
select * from po_lines_all&&&&&&&&&&&&&&&& 订单行
select * from po_line_locations_all&&&&&&&
select * from po_distributions_all&&&&&&&&& 分配
select * from po_releases_all&&&&&&&&&&&&&& 发送
select * from rcv_shipment_headers&&&&&&&&& 采购接收头
select * from rcv_shipment_lines&&&&&&&&&&& 采购接收行
select * from rcv_transactions&&&&&&&&&&&&& 接收事务处理
select * from po_agents&&&&&&&&&&&&&&&&&&&&
select * from po_vendors&&&&&&&&&&&&&&&&&&& 订单
select * from po_vendor_sites_all
select * from ra_customers&&&&&&&&&&&&&&&&& 客户
select * from ra_addresses_all&&&&&&&&&&&&& 地址
select * from ra_site_uses_all&&&&&&&&&&&&& 用户
select * from oe_order_headers_all&&&&&&&&& 销售头
select * from oe_order_lines_all&&&&&&&&&&& 销售行
select * from wsh_new_deliveries&&&&&&&&&&& 发送
select * from wsh_delivery_details
select * from wsh_delivery_assignments
select * from gl_sets_of_books&&&& 总帐
select * from gl_code_combinations gcc where gcc.summary_flag='Y'&& 科目组合
select * from gl_balances&&&&&&&&& 科目余额
select * from gl_je_batches&&&&&&& 凭证批
select * from gl_je_headers&&&&&&& 凭证头
select * from gl_je_lines&&&&&&&&& 凭证行
select * from gl_je_categories&&&& 凭证分类
select * from gl_je_sources&&&&&&& 凭证来源
select * from gl_summary_templates 科目汇总模板
select * from gl_account_hierarchies 科目汇总模板层次
select * from ar_batches_all&&&&&&&&&&&&&&&& 事务处理批
select * from ra_customer_trx_all&&&&&&&&&&& 发票头
select * from ra_customer_trx_lines_all&&&&& 发票行
select * from ra_cust_trx_line_gl_dist_all&& 发票分配
select * from ar_cash_receipts_all&&&&&&&&&& 收款
select * from ar_receivable_applications_all 核销
select * from ar_payment_schedules_all&&&&&& 发票调整
select * from ar_adjustments_all&&&&&&&&&&&& 会计分录
select * from ar_distributions_all&&&&&&&&&& 付款计划
select * from ap_invoices_all&&&&&&&&&&&&&& 发票头
select * from ap_invoice_distributions_all 发票行
select * from ap_payment_schedules_all&&&&& 付款计划
select * from ap_check_stocks_all&&&&&&&&&& 单据
select * from ap_checks_all&&&&&&&&&&&&&&&& 付款
select * from ap_bank_branches&&&&&&&&&&&&& 银行
select * from ap_bank_accounts_all&&&&&&&&& 银行帐号
select * from ap_invoice_payments_all&&&&&& 核销
========================华丽的分割线=========================
INV库存organization 两个含义:1. 经营单位，A/B/C分公司，A下面有A1，A2等工厂，主题目标是为了独立核算此组织ORG，ORG_ID;2. 库存组织，例如制造商的仓库，例如A1，A2等工厂Organization_
HR_ORGANIZATION_UNITS －Org_organization_definitions Mtl_subinventory_ 库存组织单位MTL_PARAMETERS -库存组织参数（没有用ID，直接用name）MTL_SYSTEM_ITEMS_b -物料信息（同上，应用了库存组织name）MTL_SECONDARY_INVENTORIES -子库存组织 - MTL_ITEM_LOCATTIONS -货位 - SUBINVENTROY_CODE
Mtl_Material_Transactions - (库存)物料事物表成本 mtl_transaction_accountstransaction_cost是事物成本；ACTUAL_COST是通过成本算法计算出来的实际成本，主计量单位
现有量汇总历史记录（正负合计）Mtl_Material_TransactionsMTL_ONHAND_QUANTITIES现有量表，组织/子库存/货位/物品 summary可能按照挑库先进先出统计，如果设置了"不允许负库存"，这样就不可能出现负数
PO请购单头表Po_Requisition_Headers_all行表Po_Requisition_lines_all采购订单PO_HEADER_ALLPO_LINES_ALL采购接收－退货/组织间转移/正常状态 都需要使用这个模块RCV_TRANSACTIONS1. 接收100单位货物,放入&待质检&货位2. 接受/拒绝3. 库存/退回有三个不同的状态！例如：接收100个，80个接受入库，20个退回，那么有80个接受事务/20个退回事物select TRANSACTION_TYPE，DESTINATION_TYPE_CODE from RCV_TRANSACTIONS可以看出以下阶段：A1.RECEIVE & RECEIVINGA2.ACCEPT & RECEIVINGA3.DELIERY & INVETORY(影响库存现有量)
如果按照正常模式，最后会触发产生MTL_MATERIAL_TRANSACTIONS
销售订单OE_ORDER_headers_allSOLD_FROM_ORG_IDSOLD_TO_ORG_ID 就是客户层SHIP_FROM_ORG_IDSHIP_TO_ORG_ID 就是客户收货层INVOICE_TO_ORG_ID 就是客户收单层DELIVER_TO_ORG_ID和客户结构有关客户 RA_customers 客户Address Ra_AddressesAddress 货品抵达 site RA_SITE_USES_ALLAddress 发票抵达 site OE_ORDER_LINEs_all
GL凭证gl_je_batches凭证日期:&&&&&&&&&&&&&&& DEFAULT_EFFECTIVE_DATE会计期间:&&&&&&&&&&&&&&& DEFAULT_PERIOD_NAME原币种凭证批借贷方汇总: RUNNING_TOTAL_DR/CR 比如美元本位币凭证批借贷方汇总: RUNNING_TOTAL_ACCOUNTED_DR/CR gl_je_headers日记账头信息批号:&&&& JE_BATCH_ID会计期间: PERIOD_NAME币种:&&&& CURRENCY_CODE汇率类型: CURRENCY_CONVERSION_TYPE汇率日期: CURRENCY_CONVERSION_DATE帐套:&&&& SET_OF_BOOKS_ID 参考 GL_SETS_OF_BOOKS凭证类型: JE_CATEGORY 参考 GL_JE_SOURCES凭证来源: JE_SOURCE
gl_je_lines日记账体信息CODE_COMBINATION_ID 科目组合编号
GL_BALANCES 总帐余额PERIOD_NET_DR/CR 净值BEGIN_BALANCE_DR/CR 期初额
AR应收发票RA_CUSTOMER_TRX_ALL&&& CUSTOMER_TRX_ID 发票编号&&& BILL_TO_SITE_USE_ID 客户收单方编号&&& PRIMARY_SALES_ID销售员REFERENCE是Oracle提供的外部编号输入框，但是由于版本问题和长度(&=30)，不建议用户使用，如果要使用外部编号，请使用说明性弹性域
RA_CUSTOMER_TRX_LINES_ALL&&& LINE_ID&&&&&&&&&&& 行号&&& INVENTORY_ITEM_ID 可以为空，比如非物料的服务，只在DE script ION中出现 /税行&&& DE script ION&&&&& &&& QUANTITY_INVOICE&& 开票数量&&& LINE_TYPE&&&&&&&&& 行类型 (一般/税)&&& EXTEND_PRICE&&&&&& 本行金额注意：税行是隐藏行，所以至少会有两行
收款情况AR_CASH_RECEIPTS_ALL（还包含了非收款信息）&&& CASH_RECEIPT_ID 内部code&&& RECEIPT_NUMBER&& 收款号&&& RECEIPT_DATE&&&& 收款日期&&& AMOUNT&&&&&&&&&& 总额&&& RECEIPT_TYPE&&&& 现金/杂项 Cash/Misc&&& FUNCTIONAL_AMOUNT 本位币计量金额&& UI上为RECEIPTS && 核销关系不是一一对应，也不是一次核销100%,UI上右下方的Application 按钮&& AR_RECEIVABLE_APPLICATIONS_ALL&&& APPLIED_CUSTOMER_TRX_ID&& 发票编号&&& APPLIED_CUSTOMER_TRX_LINE_ID&& 发票行编号&&& STATUS APP表示核销 /UNAPP表示未核销&&&&&&& AMOUNT_APPLIED&&&&&&&&&&&&&&&& 匹配金额&&& 注意:红冲收款报表时间跨月的问题；必须联查 AR_CASH_RECEIPTS_ALL和&& AR_CASH_RECEIPT_HISTORY_ALL
AP应付帐款(是我方人员按照供应商提供的纸张发票信息录入)UI 上的invoiceAP_INVOICES_ALL
实际付款PAYMENTAP_CHECKS_ALL
核销关系 同AR，右下方的Payment 按钮AP_INVOICE_PAYMENTS_ALL客户余额表，情况比较复杂:比如两个用户合并，应收应付差额，预付款
资产信息FA_ADDITIONS名称编号分类数量
资产类别FA_CATEGORIES
资产帐簿FA_BOOK_CONTROLS 和会计帐簿有什么关系？FA_BOOKS UI中的InquiryMothed是折旧方法(直线法/产量法)
FA_DISTRIBUTION_HISTORY分配assignment，给什么部门使用多少LOCATION_ID 部门 联查FA_LOCATIONS
折旧信息(分摊方法)FA_DEPRN_DETAILperiod_counter 折旧期间编号
折旧事务(新增、重建、转移、报废)FA_TRANSACTION_HEADERS
========================华丽的分割线=========================
fnd_user －－－ 系统用户表
po_vendors －－－ 供应商信息表
po_vendor_sites －－－ 供应商地点信息表
hr_organization_units －－－ 组织及库存组织表
per_people_f －－－ 员工表
wip_entities －－－ 作业名信息表
wip_discrete_jobs －－－ 离散作业表
wip_requirement_operations －－－ 作业名物料需求发放表
po_headers_all －－－ 采购订单头表
po_lines_all －－－ 采购订单行表
po_line_locations_all －－－ 采购行地点表
rcv_transactions －－－ 接收交易表
bom_bill_of_materials －－－ 物料清单表
bom_inventory_components －－－ 物料清单构成表
mtl_system_items －－－ 物料主表
mtl_onhand_quantities －－－ 库存数据表
mtl_item_locations －－－ 项目货位表
mtl_material_transactions －－－ 出入库记录表
mtl_supply －－－ 供应表
mtl_demand －－－ 需求表
----＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝-下面的是用于修改表单注册情况＝＝＝＝＝＝＝＝-------select * from FND_FORM_VL where form_name='出货信息' order by last_update_date descupdate FND_FORM set form_name='OUTINVINFO' where form_id=58864select * from fnd_form where form_name='出货信息'-------＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝-----------select item as 物料,subinventory as 子库存,locator as 货位,results_transaction_uom as 单位 from MTL_TXN_REQUEST_HEADERS_Vselect lot_number as 批次,LOT_EXPIRATION_DATE as 到期日,pimary_quantity as 数量 from MTL_TXN_REQUEST_LINES_V/*==================物料发送请求行视图==================================*/select * from MTL_TXN_REQUEST_LINES_Vselect * from MTL_TXN_REQUEST_HEADERS_V-----其他信息从OE上取---------organization_id = :parameter.org_id ----------select * from MTL_ONHAND_LOCATOR_Vselect * from MTL_MATERIAL_TRANSACTIONS_TEMPselect * from MTL_SERIAL_NUMBERS_TEMPselect * from MTL_TRANSACTION_LOTS_TEMP---------------------------------------------------------通过PO, 找点收单号: =========================================================== 通过PO, 找点收单号:作者: moonsoft(http://moonsoft.itpub.net)发表于:
16:20分类: 分销 出处: http://moonsoft.itpub.net/post/---------------------------------------------------------------select rsh.receipt_num from po_headers_all poh,rcv_shipment_headers rsh, rcv_shipment_lines rsl, po_lines_all pol, po_line_locations_all pollwherepoh.segment1=''andpoh.po_header_id=pol.po_header_idand pol.po_line_id=poll.po_line_idand poll.line_location_id=rsl.po_line_location_idand rsh.SHIPMENT_HEADER_ID=rsl.shipment_header_id/*--------------------------//接收事务处理------------------------************/select * from RCV_TRANSACTIONS_Vselect * from RCV_TRANSACTIONS_INTERFACEselect * from MTL_TRANSACTION_LOTS_TEMPselect * from MTL_SERIAL_NUMBERS_TEMP ----------条码-----------select * from QA_RESULTS_Vselect * from ic_lots_mstselect * from mtl_serial_numbers ----------条码表-----------select * from wms_license_plate_numbersselect * from rcv_lots_supplyselect * from oe_lot_serial_numbers ----------销售订单批次条码---------------select * from rcv_transactions -----//接收事务处理----select * from sy_reas_cds select * from mtl_serial_numbers_all_vselect * from qa_plan_char_value_lookupsselect * from mtl_lot_numbersselect * from mtl_serial_numbers-------------序列号select * from wip_operations_all_vselect * from cs_counter_valuesselect * from wip_discrete_jobs_all_vselect * from cs_incidentsselect * from qa_ahl_mrselect * from cs_countersselect * from qa_csi_item_instancesselect * from mtl_system_items_kfvselect * from wms_lpn_contentsselect * from ic_item_mstselect * from ic_tran_pndselect * from ic_loct_invselect * from ic_loct_mstselect * from hr_employees------------人事人员select * from pjm_projects_all_vselect * from PA_TASKS_EXPEND_Vselect * from wip_osp_jobs_val_vselect * from mtl_kanban_cardsselect * 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_interfaceselect * from PO_LINE_LOCATIONSselect * 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_interfaceselect * 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_typesselect * 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_interfaceselect * 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 ---------------------------------------------------签证分类select t.meaning from fnd_lookup_values_vl t Where t.lookup_type='CUX_FC_QZYY'-- 任务IDSelect Distinct A.Task_Number,A.Task_Name From pa_tasks A---------------------------//发运------------------------------select * from wsh_new_deliveries_vselect * from mtl_txn_request_lines_vselect * from oe_order_headers_vselect * from wsh.wsh_delivery_details-------------------------//出货信息--------------------------select * from oe_lot_serial_numbers ----订单批次与序列号select * from ic_lots_mst select * from mtl_serial_numbers---------序列号 select * from rcv_transactions ---------接收处理select * from gml_recv_trans_mapselect * from ic_tran_pndselect * from ic_loct_invselect reason_code,reason_desc1 from sy_reas_cds order by 1select * from MTL_MATERIAL_TRANSACTIONS--是物料交易表，---------它存放着相关库存物料的每一笔交易，或库存更新的每一笔数据----物料处理,(库存)物料事物表select * from MTL_CONSUMPTION_TXN_TEMPselect * from hr_locations_all -------------收货地点档案----------------select * from hz_locations------交货地点select * from wms_lpn_contentsselect * from mtl_subinventories_val_v ------------子库----------------select * from mtl_object_genealogyselect * from mtl_lot_numbers-----------物料批号select * from mtl_lot_issues_val_v -----------物料批号发出 select * from wms_license_plate_numbers select * from cst_cost_groupsselect * from mtl_item_sub_val_vselect * from mtl_subinventories_trk_val_v----------select * from mtl_item_sub_trk_val_vselect * from mtl_item_sub_exp_val_vselect * from mtl_sub_exp_val_vselect * from mtl_so_rma_interfaceselect * from mtl_system_items-------库存、工程和采购物料的明细-物料信息--select * from mtl_item_revisions----------修订select * from bom_departmentsselect * from wip_lines_all_vselect * from wip_entitiesselect * from wip_discrete_jobs_all_vselect * from wsh_inv_delivery_details_v---------库存存货发放明细select * from mtl_txn_request_lines--------请求select * from mtl_material_transactions_tempselect * from mtl_transaction_types------物料处理类型select * from pjm_unit_numbers_lov_vselect * from mtl_sales_orders----------------销售订单select * from mtl_secondary_inventories ---------select * from mtl_lot_numbers----------select * from pjm_tasks_vselect * from pjm_projects_vselect * from pjm_project_parametersselect * from fnd_user --------------系统用户select * from mtl_txn_request_headers-------------头select * from mtl_txn_request_lines------------体select * from mtl_onhand_quantities_detail----物料的库存明细--------select * from fnd_folders------------select * from mtl_item_sub_inventoriesselect * from mtl_kanban_cards-------物料看板select * from mtl_physical_inventories_v------物理库存select * from mtl_category_sets_vl---物料类别select * from mtl_system_items_vlselect * from mtl_txn_source_typesselect * from mtl_transaction_types---处理类型select * from org_organization_definitions------库存组织 where orselect * from mtl_item_status-----物料状态select * from mtl_employees_current_view------员工select * from po_suppliers_val_v--------------采购供应商视图select * from mtl_employees_view-----------------员工select * from mtl_transaction_lots_tempselect * from pa_projects_expend_vselect * from pa_tasks_expend_vselect * from pa_organizations_expend_vselect * from mtl_onhand_quantities_detail---------物料现存量明细select * from mtl_lot_numbers----物料批号select * from mtl_transaction_reasons------------物料处理原因select * from mtl_item_uoms_view--------------物料单位mtl_units_of_measureselect * from mtl_so_rma_interfaceselect * from mtl_system_items------------物料项select * from mtl_item_sub_ast_trk_val_vselect * from mtl_lot_issues_val_v-------------批次-select * from mtl_so_rma_interfaceselect * from mtl_sub_ast_trk_val_v ---------------子库select * from pa_expenditure_typesselect * from MTL_TXN_REQUEST_LINES_V--------------发送请求select * from MTL_SERIAL_NUMBERS_TEMPselect * from MTL_TRANSACTION_LOTS_TEMPselect * from MTL_MATERIAL_TRANSACTIONS_TEMPselect * from MTL_ITEM_LOCATTIONS---------------货位Select * from Po_Requisition_Headers_all------------请购单头表Select * from Po_Requisition_lines_all----------体表Select * from PO_HEADER_ALL---------采购订单头Select * from PO_LINES_ALL---采购订单体select * from wsh_pick_slip_v select * from mtl_system_items_vl msi -- bug# 3306781 select * from wsh_delivery_details wdd select * from mtl_txn_request_lines mtrl select * from mtl_txn_request_headers mtrhselect * from wsh_delivery_assignments wda select * from wsh_new_deliveries wnd select * from oe_order_lines_all oola select * from oe_sets os select * from wsh_pick_grouping_rules wpgr select * from hz_locations -------交货位置表select * from hr_locations_all-------收貨位置表Select flex_value_set_id From apps.fnd_flex_value_setsselect * from MTL_TXN_REQUEST_LINES_V --查找物料搬运单SELECT TRANSACTION_TYPE_NAME,TRANSACTION_TYPE_ID,TRANSACTION_ACTION_ID,TRANSACTION_SOURCE_TYPE_ID,LINE_ID,REQUEST_NUMBER,HEADER_ID,MOVE_ORDER_TYPE,MOVE_ORDER_TYPE_NAME,LINE_NUMBER,ORGANIZATION_ID,INVENTORY_ITEM_ID,REVISION,FROM_SUBINVENTORY_CODE,FROM_LOCATOR_ID,TO_SUBINVENTORY_CODE,FROM_SUB_LOCATOR_TYPE,TO_LOCATOR_ID,TO_ACCOUNT_ID,LOT_NUMBER,SERIAL_NUMBER_START,SERIAL_NUMBER_END,UNIT_NUMBER,UOM_CODE,QUANTITY,REQUIRED_QUANTITY,QUANTITY_DELIVERED,QUANTITY_DETAILED,DATE_REQUIRED,REASON_ID,REFERENCE,REFERENCE_ID,REFERENCE_TYPE_CODE,PROJECT_ID,TASK_ID,TRANSACTION_HEADER_ID,LINE_STATUS,STATUS_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,CREATED_BY,REQUEST_ID,CREATION_DATE,PROGRAM_APPLICATION_ID,PROGRAM_ID,PROGRAM_UPDATE_DATE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15,ATTRIBUTE_CATEGORY,TO_SUB_LOCATOR_TYPE,FROM_SUB_ASSET,FROM_SUB_QUANTITY_TRACKED,FROM_SUB_MATERIAL_ACCOUNT,TXN_SOURCE_ID,TXN_SOURCE_LINE_ID,TXN_SOURCE_LINE_DETAIL_ID,PRIMARY_QUANTITY,TO_ORGANIZATION_ID,PICK_STRATEGY_ID,PUT_AWAY_STRATEGY_ID,SHIP_TO_LOCATION_ID FROM MTL_TXN_REQUEST_LINES_V WHERE organization_id = '117' AND -1=-1 and ( mtl_txn_request_lines_v.move_order_type != 6 AND mtl_txn_request_lines_v.request_number between '4009' AND '4009' AND mtl_txn_request_lines_v.line_status in (3,7,9) ) and (REQUEST_NUMBER='4009') order by REQUEST_NUMBER,MOVE_ORDER_TYPE_NAME,LINE_NUMBER------哪个用户锁定了哪个表的SQL----SELECT c.owner,c.object_name,c.object_type,fu.user_name locking_fnd_user_name,fl.start_time locking_fnd_user_login_time,vs.module,vs.machine,vs.osuser,vlocked.oracle_username,vs.SID,vp.pid,vp.spid AS os_process,vs.serial#,vs.status,vs.saddr,vs.audsid,vs.processFROM fnd_logins fl,fnd_user fu,v$locked_object vlocked,v$process vp,v$session vs,dba_objects cWHERE vs.SID = vlocked.session_idAND vlocked.object_id = c.object_idAND vs.paddr = vp.addrAND vp.spid = fl.process_spid(+)AND vp.pid = fl.pid(+)AND fl.user_id = fu.user_id(+)--AND c.object_name LIKE '%' || UPPER('&tab_name_leaveblank4all') || '%'AND NVL(vs.status,'XX') != 'KILLED';--------------select * from oe_ra_cust_trx_hdr_vselect * from ar_payment_schedules_allselect * from oe_ra_customers_v-----------客户名称 select * from OE_PO_REQUISITION_LINES_V------------==================select fyhzt.delivery_detail_id,fyhzt.source_code as 源单类,fyhzt.source_line_id as 源单行号,fyhzt.source_header_id as 源单头号,fyhzt.header_number as 单据号,fyhzt.line_number as 行号,fyhzt.ship_method_code as 发运方式,fyhzt.inventory_item_id as 物料ID,fyhzt.requested_quantity as 请求数量,fyhzt.shipped_quantity_uom as 发运单位,fyhzt.shipped_quantity as 已发运,fyhzt.requested_quantity_uom as 请求单位,fyhzt.ship_set_id,fyhzt.line_number as 批次号,fyhzt.serial_number as 序列号从,fyhzt.pick_status as 挑库状态,fyhzt.pick_meaning as 挑库状态名称,fyhzt.delivery_id,fyhzt.delivery_name,fyhzt.delivery_status,fyhzt.delivery_status_meaning as 发运状态,fyhzt.organization_id as 公司,fyhzt.initial_pickup_location_id as 地点ID,fyhzt.initial_pickup_location as 地点,fyhzt.ultimate_dropoff_location_id,fyhzt.ultimate_dropoff_location,fyhzt.date_shipped,fyhzt.date_received,fyhzt.to_serial_number as 序列号止from WSH_DELIVERY_LINE_STATUS_V fyhzt-------发运行状态-------------------------select * from OE_ORDER_HEADERS_V-------付款方式select distinct t.name, t.description from ra_terms t order by t.name--------收单地点select * from hz_cust_site_uses_all-------业务员select * from JTF_RS_DEFRESOURCES_VL-----------公司 名称select * from HR_ALL_ORGANIZATION_UNITS where organization_id=103}