表
call fnd_global.APPS_INITIALIZE(1318,50583,401)
select fnd_profile.VALUE('ORG_ID') FROM DUAL
select * from hr_operating_units hou where hou.organization_id=204
--fnd
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 进程表
--inv
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'
--po
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
--oe
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
--gl
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 科目汇总模板层次
--ar
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 付款计划
--ap
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_id;
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_accounts
transaction_cost是事物成本;
ACTUAL_COST是通过成本算法计算出来的实际成本,主计量单位
现有量
汇总历史记录(正负合计)
Mtl_Material_Transactions
MTL_ONHAND_QUANTITIES现有量表,组织/子库存/货位/物品 summary可能按照挑库先进先出统计,如果设置了"不允许负库存",这样就不可能出现负数
PO
请购单头表
Po_Requisition_Headers_all
行表
Po_Requisition_lines_all
采购订单
PO_HEADER_ALL
PO_LINES_ALL
采购接收-退货/组织间转移/正常状态 都需要使用这个模块
RCV_TRANSACTIONS
1. 接收100单位货物,放入"待质检"货位
2. 接受/拒绝
3. 库存/退回
有三个不同的状态!例如:接收100个,80个接受入库,20个退回,那么有80个接受事务/20个退回事物
select TRANSACTION_TYPE,DESTINATION_TYPE_CODE from RCV_TRANSACTIONS
可以看出以下阶段:
A1.RECEIVE – RECEIVING
A2.ACCEPT – RECEIVING
A3.DELIERY – INVETORY(影响库存现有量)
如果按照正常模式,最后会触发产生MTL_MATERIAL_TRANSACTIONS
销售订单
OE_ORDER_headers_all
SOLD_FROM_ORG_ID
SOLD_TO_ORG_ID 就是客户层
SHIP_FROM_ORG_ID
SHIP_TO_ORG_ID 就是客户收货层
INVOICE_TO_ORG_ID 就是客户收单层
DELIVER_TO_ORG_ID
和客户结构有关
客户 RA_customers
客户Address Ra_Addresses
Address 货品抵达 site RA_SITE_USES_ALL
Address 发票抵达 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 上的invoice
AP_INVOICES_ALL
实际付款PAYMENT
AP_CHECKS_ALL
核销关系 同AR,右下方的Payment 按钮
AP_INVOICE_PAYMENTS_ALL客户余额表,情况比较复杂:比如两个用户合并,应收应付差额,预付款
资产信息FA_ADDITIONS
名称
编号
分类
数量
资产类别
FA_CATEGORIES
资产帐簿
FA_BOOK_CONTROLS 和会计帐簿有什么关系?
FA_BOOKS
UI中的Inquiry
Mothed是折旧方法(直线法/产量法)
FA_DISTRIBUTION_HISTORY分配assignment,给什么部门使用多少
LOCATION_ID 部门 联查FA_LOCATIONS
折旧信息(分摊方法)
FA_DEPRN_DETAIL
period_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 desc
update FND_FORM set form_name='OUTINVINFO' where form_id=58864
select * from fnd_form where form_name='出货信息'
commit;
-------===========================-----------
select item as 物料,subinventory as 子库存,locator as 货位,results_transaction_uom as 单位 from MTL_TXN_REQUEST_HEADERS_V
select lot_number as 批次,LOT_EXPIRATION_DATE as 到期日,pimary_quantity as 数量 from MTL_TXN_REQUEST_LINES_V
/*==================物料发送请求行视图==================================*/
select * from MTL_TXN_REQUEST_LINES_V
select * from MTL_TXN_REQUEST_HEADERS_V
-----其他信息从OE上取
---------organization_id = :parameter.org_id ----------
select * from MTL_ONHAND_LOCATOR_V
select * from MTL_MATERIAL_TRANSACTIONS_TEMP
select * from MTL_SERIAL_NUMBERS_TEMP
select * from MTL_TRANSACTION_LOTS_TEMP
---------------------------------------------------------
通过PO, 找点收单号:
===========================================================
通过PO, 找点收单号:
作者: moonsoft(http://moonsoft.itpub.net)
发表于: 2006.05.08 16:20
分类: 分销
出处: http://moonsoft.itpub.net/post/15182/86513
---------------------------------------------------------------
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 poll
where
poh.segment1='20600021'
and
poh.po_header_id=pol.po_header_id
and
pol.po_line_id=poll.po_line_id
and
poll.line_location_id=rsl.po_line_location_id
and
rsh.SHIPMENT_HEADER_ID=rsl.shipment_header_id
/*--------------------------//接收事务处理------------------------************/
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 ---------
------------------------------------------签证分类
select t.meaning from fnd_lookup_values_vl t Where t.lookup_type='CUX_FC_QZYY'
-- 任务ID
Select Distinct A.Task_Number,A.Task_Name From pa_tasks A
---------------------------//发运------------------------------
select * from wsh_new_deliveries_v
select * from mtl_txn_request_lines_v
select * from oe_order_headers_v
select * 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_map
select * from ic_tran_pnd
select * from ic_loct_inv
select reason_code,reason_desc1 from sy_reas_cds order by 1
select * from MTL_MATERIAL_TRANSACTIONS--是物料交易表,
---------它存放着相关库存物料的每一笔交易,或库存更新的每一笔数据
----物料处理,(库存)物料事物表
select * from MTL_CONSUMPTION_TXN_TEMP
select * from hr_locations_all -------------收货地点档案----------------
select * from hz_locations------交货地点
select * from wms_lpn_contents
select * from mtl_subinventories_val_v ------------子库----------------
select * from mtl_object_genealogy
select * from mtl_lot_numbers-----------物料批号
select * from mtl_lot_issues_val_v -----------物料批号发出
select * from wms_license_plate_numbers
select * from cst_cost_groups
select * from mtl_item_sub_val_v
select * from mtl_subinventories_trk_val_v----------
select * from mtl_item_sub_trk_val_v
select * from mtl_item_sub_exp_val_v
select * from mtl_sub_exp_val_v
select * from mtl_so_rma_interface
select * from mtl_system_items-------库存、工程和采购物料的明细-物料信息--
select * from mtl_item_revisions----------修订
select * from bom_departments
select * from wip_lines_all_v
select * from wip_entities
select * from wip_discrete_jobs_all_v
select * from wsh_inv_delivery_details_v---------库存存货发放明细
select * from mtl_txn_request_lines--------请求
select * from mtl_material_transactions_temp
select * from mtl_transaction_types------物料处理类型
select * from pjm_unit_numbers_lov_v
select * from mtl_sales_orders----------------销售订单
select * from mtl_secondary_inventories ---------
select * from mtl_lot_numbers----------
select * from pjm_tasks_v
select * from pjm_projects_v
select * from pjm_project_parameters
select * 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_inventories
select * from mtl_kanban_cards-------物料看板
select * from mtl_physical_inventories_v------物理库存
select * from mtl_category_sets_vl---物料类别
select * from mtl_system_items_vl
select * from mtl_txn_source_types
select * from mtl_transaction_types---处理类型
select * from org_organization_definitions------库存组织 where or
select * 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_temp
select * from pa_projects_expend_v
select * from pa_tasks_expend_v
select * from pa_organizations_expend_v
select * from mtl_onhand_quantities_detail---------物料现存量明细
select * from mtl_lot_numbers----物料批号
select * from mtl_transaction_reasons------------物料处理原因
select * from mtl_item_uoms_view--------------物料单位mtl_units_of_measure
select * from mtl_so_rma_interface
select * from mtl_system_items------------物料项
select * from mtl_item_sub_ast_trk_val_v
select * from mtl_lot_issues_val_v-------------批次-
select * from mtl_so_rma_interface
select * from mtl_sub_ast_trk_val_v ---------------子库
select * from pa_expenditure_types
select * from MTL_TXN_REQUEST_LINES_V--------------发送请求
select * from MTL_SERIAL_NUMBERS_TEMP
select * from MTL_TRANSACTION_LOTS_TEMP
select * from MTL_MATERIAL_TRANSACTIONS_TEMP
select * 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 mtrh
select * 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_sets
select * 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.process
FROM fnd_logins fl
,fnd_user fu
,v$locked_object vlocked
,v$process vp
,v$session vs
,dba_objects c
WHERE vs.SID = vlocked.session_id
AND vlocked.object_id = c.object_id
AND vs.paddr = vp.addr
AND 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_v
select * from ar_payment_schedules_all
select * 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