ORACLEEBS常用表
callfnd_global.APPS_INITIALIZE(1318,50583,401)
selectfnd_profile.VALUE(''ORG_ID'')FROMDUAL
selectfromhr_operating_unitshouwherehou.organization_id=204
--fnd
selectfromfnd_application
selectfromfnd_application_tlwhereapplication_id=101
selectfromfnd_application_vlwhereapplication_id=101
----值集
selectfromfnd_flex_value_sets
selectfromfnd_flex_values
selectfromfnd_flex_values_vl
----弹性域
selectfromfnd_id_flexs
selectfromfnd_id_flex_structureswhereid_flex_code=''GL#''
selectfromfnd_id_flex_segmentswhereid_flex_code=''GL#''andid_flex_num=50671
selectfromfnd_profile_options_vl
selectfromfnd_concurrent_programs程序表
selectfromfnd_concurrent_requests请求表
selectfromfnd_concurrent_processes进程表
--inv
selectfromorg_organization_definitions库存组织
selectfrommtl_parameters组织参数
selectfrommtl_system_items_bwhereinventory_item_id=171andorganization_id=204物料表
selectfrommtl_secondary_inventories子库存
selectfrommtl_item_locations货位
selectfrommtl_lot_numbers批次
selectfrommtl_onhand_quantities现有量表
selectfrommtl_serial_numbers序列
selectfrommtl_material_transactions物料事务记录
selectfrommtl_transaction_accounts会计分录
selectfrommtl_transaction_types事务类型
selectfrommtl_txn_source_types事务来源类型
selectfrommfg_lookupsmlwhereml.LOOKUP_TYPE=''MTL_TRANSACTION_ACTION''
--po
selectfrompo_requisition_headers_all请求头
selectfrompo_requisition_lines_all请求行
selectfrompo_headers_all订单头
selectfrompo_lines_all订单行
selectfrompo_line_locations_all
selectfrompo_distributions_all分配
selectfrompo_releases_all发送
selectfromrcv_shipment_headers采购接收头
selectfromrcv_shipment_lines采购接收行
selectfromrcv_transactions接收事务处理
selectfrompo_agents
selectfrompo_vendors订单
selectfrompo_vendor_sites_all
--oe
selectfromra_customers客户
selectfromra_addresses_all地址
selectfromra_site_uses_all用户
selectfromoe_order_headers_all销售头
selectfromoe_order_lines_all销售行
selectfromwsh_new_deliveries发送
selectfromwsh_delivery_details
selectfromwsh_delivery_assignments
--gl
selectfromgl_sets_of_books总帐
selectfromgl_code_combinationsgccwheregcc.summary_flag=''Y''科目组合
selectfromgl_balances科目余额
selectfromgl_je_batches凭证批
selectfromgl_je_headers凭证头
selectfromgl_je_lines凭证行
selectfromgl_je_categories凭证分类
selectfromgl_je_sources凭证来源
selectfromgl_summary_templates科目汇总模板
selectfromgl_account_hierarchies科目汇总模板层次
--ar
selectfromar_batches_all事务处理批
selectfromra_customer_trx_all发票头
selectfromra_customer_trx_lines_all发票行
selectfromra_cust_trx_line_gl_dist_all发票分配
selectfromar_cash_receipts_all收款
selectfromar_receivable_applications_all核销
selectfromar_payment_schedules_all发票调整
selectfromar_adjustments_all会计分录
selectfromar_distributions_all付款计划
--ap
selectfromap_invoices_all发票头
selectfromap_invoice_distributions_all发票行
selectfromap_payment_schedules_all付款计划
selectfromap_check_stocks_all单据
selectfromap_checks_all付款
selectfromap_bank_branches银行
selectfromap_bank_accounts_all银行帐号
selectfromap_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个退回事物
selectTRANSACTION_TYPE,DESTINATION_TYPE_CODEfromRCV_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
客户AddressRa_Addresses
Address货品抵达siteRA_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可以为空,比如非物料的服务,只在DEscriptION中出现/税行
DEscriptION
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发票行编号
STATUSAPP表示核销/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---需求表
----=====================-下面的是用于修改表单注册情况========-------
selectfromFND_FORM_VLwhereform_name=''出货信息''orderbylast_update_datedesc
updateFND_FORMsetform_name=''OUTINVINFO''whereform_id=58864
selectfromfnd_formwhereform_name=''出货信息''
commit;
-------===========================-----------
selectitemas物料,subinventoryas子库存,locatoras货位,results_transaction_uomas单位fromMTL_TXN_REQUEST_HEADERS_V
selectlot_numberas批次,LOT_EXPIRATION_DATEas到期日,pimary_quantityas数量fromMTL_TXN_REQUEST_LINES_V
/==================物料发送请求行视图==================================/
selectfromMTL_TXN_REQUEST_LINES_V
selectfromMTL_TXN_REQUEST_HEADERS_V
-----其他信息从OE上取
---------organization_id=:parameter.org_id----------
selectfromMTL_ONHAND_LOCATOR_V
selectfromMTL_MATERIAL_TRANSACTIONS_TEMP
selectfromMTL_SERIAL_NUMBERS_TEMP
selectfromMTL_TRANSACTION_LOTS_TEMP
---------------------------------------------------------
通过PO,找点收单号:
===========================================================
通过PO,找点收单号:
作者:moonsoft(http://moonsoft.itpub.net)
发表于:2006.05.0816:20
分类:分销
出处:http://moonsoft.itpub.net/post/15182/86513
---------------------------------------------------------------
selectrsh.receipt_num
frompo_headers_allpoh,
rcv_shipment_headersrsh,
rcv_shipment_linesrsl,
po_lines_allpol,
po_line_locations_allpoll
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
/--------------------------//接收事务处理------------------------/
selectfromRCV_TRANSACTIONS_V
selectfromRCV_TRANSACTIONS_INTERFACE
selectfromMTL_TRANSACTION_LOTS_TEMP
selectfromMTL_SERIAL_NUMBERS_TEMP----------条码-----------
selectfromQA_RESULTS_V
selectfromic_lots_mst
selectfrommtl_serial_numbers----------条码表-----------
selectfromwms_license_plate_numbers
selectfromrcv_lots_supply
selectfromoe_lot_serial_numbers----------销售订单批次条码---------------
selectfromrcv_transactions-----//接收事务处理----
selectfromsy_reas_cds
selectfrommtl_serial_numbers_all_v
selectfromqa_plan_char_value_lookups
selectfrommtl_lot_numbers
selectfrommtl_serial_numbers-------------序列号
selectfromwip_operations_all_v
selectfromcs_counter_values
selectfromwip_discrete_jobs_all_v
selectfromcs_incidents
selectfromqa_ahl_mr
selectfromcs_counters
selectfromqa_csi_item_instances
selectfrommtl_system_items_kfv
selectfromwms_lpn_contents
selectfromic_item_mst
selectfromic_tran_pnd
selectfromic_loct_inv
selectfromic_loct_mst
selectfromhr_employees------------人事人员
selectfrompjm_projects_all_v
selectfromPA_TASKS_EXPEND_V
selectfromwip_osp_jobs_val_v
selectfrommtl_kanban_cards
selectfromhr_locations_all--------人事组织档案-----
selectfromhr_locations_all_tl-------同上
selectfrommtl_serial_numbers_all_v---------序列视图
selectfromhz_parties----------
selectfrompo_pos_val_v
selectfromrcv_transactions_interface
selectfromPO_LINE_LOCATIONS
selectfromPO_REQUISITION_LINES
selectfromwip_discrete_jobs_all_v
selectfromoke_k_headers_lov_v
selectfromoke_k_lines_full_v
selectfromoke_k_deliverables_vl
selectfromOE_SOLD_TO_ORGS_V------------
selectfromcst_cost_groups--------
selectfromrcv_shipment_headers----------发运头
selectfromrcv_shipment_lines--------发运体
selectfromrcv_transactions_interface
selectfromoe_order_lines_all-----------订单
selectfromoe_order_headers_all---------订单
selectfromoe_transaction_types_all------订单处理\交易类型
selectfromMTL_TRANSACTION_TYPES-------交易的类型--
selectfromoe_transaction_types_tl-------订单处理类型
selectfromrcv_transactions------接收事务处理
selectfromrcv_supply-----------
selectfromoe_transaction_types
selectfromoe_po_enter_receipts_v
selectfrommtl_customer_items_all_v
selectfrommtl_lot_issues_val_v------------
selectfrommtl_uom_conversions-----------
selectfrommtl_uom_class_conversions--------------
selectfrompo_lines_supplier_items_v
selectfromper_all_people_f---------------
selectfromfinancials_system_parameters
selectfromorg_freight------运输组织--------
selectfrommtl_supply-------------物料供给
selectfromorg_organization_definitions--------------库存组织定义
selectfrompo_vendor_sites
selectfromrcv_sources_both_val_v----------------
selectfromrcv_suppliers_val_v-----------
selectfromhr_locations_all---------
selectfromhr_locations_all_tl------------
selectfrommtl_item_revisions-----------
selectfrommtl_system_items_kfv----正规ID编码,------
selectfrompo_requisition_lines
selectfromfinancials_system_parameters
selectfrompo_lookup_codes----------------
selectfrompo_requisition_headers
selectfromrcv_shipment_lines---------
selectfromrcv_transactions------------
selectfrompo_line_locations
selectfromhr_locations_all_tl-----------
selectfrompo_releases
selectfrompo_pos_all_v
selectfrompo_pos_val_v
selectfromper_all_people_f------------
selectfromrcv_transactions_interface
selectfrommtl_serial_numbers------------------SERIAL----------
selectfrommtl_transaction_lots_temp
selectfrommtl_employees_view----------
selectfrompo_suppliers_val_v---------------
selectfrommtl_employees_current_view-------------
selectfrommtl_item_status-------------------物料项状态基础表---------
selectfromorg_organization_definitions------------
selectfrommtl_secondary_inventories-----子库存组织---------
selectfrommtl_transaction_types------------
selectfrommtl_txn_source_types-----------
selectfrommtl_system_items_vl------------
selectfrommtl_system_items_kfv--------
selectfrommtl_category_sets_vl---------
selectfrommtl_physical_inventories_v----------
selectfrommtl_kanban_cards
selectfrommtl_item_sub_inventories
selectfromfnd_folders-------
selectfromfnd_user--------系统用户
selectfromso_order_types_all----------销售订单类型
selectfromoe_order_headers_all---------
selectfromqa_customers_lov_v---------
selectfromqa_sales_orders_lov_v-----------
selectfromPO_VENDORS-----采购供货方-----
selectfrompo_shipments_all_v
selectfrompo_lines_val_v
selectfrompo_pos_val_v
selectfrommtl_task_v
selectfrompjm_projects_all_v
selectfromqa_customers_lov_v---
selectfrommtl_item_revisions----
selectfrommtl_category_sets----
selectfromwip_operations_all_v
selectfromwip_first_open_schedule_v
selectfromwip_discrete_jobs_all_v
selectfromwip_lines_val_v
selectfrommtl_item_uoms_view-----
selectfrombom_resources_val_v
selectfrombom_departments_val_v
selectfromqa_plan_char_value_lookups---------
selectfromqa_plans-------
selectfromqa_specs_v
selectfromqa_specs_val_v
selectfrompo_lookup_codes-----
selectfromhr_employees_current_v--------
selectfrompo_quality_codes
selectfrommtl_transaction_reasons--库存相关接转信息----
selectfrommtl_uom_conversions_val_v----
selectfrommtl_uom_class_conversions----
selectfromhr_locations_all--------
selectfromhr_locations_all_tl--------
selectfromhz_locations-------
selectfromhz_party_sites---------
selectfromhz_cust_site_uses_all--------
selectfromhz_cust_acct_sites_all---------
selectfromhz_cust_accounts-----------
selectfromoe_order_lines_all-----------
selectfromoe_drop_ship_sources
selectfromrcv_trx_int_lots_v
selectfrommtl_rma_serial_temp
selectfromrcv_trx_int_serials_v
selectfrompo_distributions
selectfrompjm_projects_all_v
selectfrompo_distributions
selectfromhr_locations_all_tl-----------
selectfromhr_employees_current_v-------
selectfrompo_lookup_codes-----------
selectfrompjm_projects_all_v
selectfrompa_tasks_expend_v
selectfrommtl_kanban_cards
selectfromqa_plans_val_v---------
------------------------------------------签证分类
selectt.meaningfromfnd_lookup_values_vltWheret.lookup_type=''CUX_FC_QZYY''
--任务ID
SelectDistinctA.Task_Number,A.Task_NameFrompa_tasksA
---------------------------//发运------------------------------
selectfromwsh_new_deliveries_v
selectfrommtl_txn_request_lines_v
selectfromoe_order_headers_v
selectfromwsh.wsh_delivery_details
-------------------------//出货信息--------------------------
selectfromoe_lot_serial_numbers----订单批次与序列号
selectfromic_lots_mst
selectfrommtl_serial_numbers---------序列号
selectfromrcv_transactions---------接收处理
selectfromgml_recv_trans_map
selectfromic_tran_pnd
selectfromic_loct_inv
selectreason_code,reason_desc1fromsy_reas_cdsorderby1
selectfromMTL_MATERIAL_TRANSACTIONS--是物料交易表,
---------它存放着相关库存物料的每一笔交易,或库存更新的每一笔数据
----物料处理,(库存)物料事物表
selectfromMTL_CONSUMPTION_TXN_TEMP
selectfromhr_locations_all-------------收货地点档案----------------
selectfromhz_locations------交货地点
selectfromwms_lpn_contents
selectfrommtl_subinventories_val_v------------子库----------------
selectfrommtl_object_genealogy
selectfrommtl_lot_numbers-----------物料批号
selectfrommtl_lot_issues_val_v-----------物料批号发出
selectfromwms_license_plate_numbers
selectfromcst_cost_groups
selectfrommtl_item_sub_val_v
selectfrommtl_subinventories_trk_val_v----------
selectfrommtl_item_sub_trk_val_v
selectfrommtl_item_sub_exp_val_v
selectfrommtl_sub_exp_val_v
selectfrommtl_so_rma_interface
selectfrommtl_system_items-------库存、工程和采购物料的明细-物料信息--
selectfrommtl_item_revisions----------修订
selectfrombom_departments
selectfromwip_lines_all_v
selectfromwip_entities
selectfromwip_discrete_jobs_all_v
selectfromwsh_inv_delivery_details_v---------库存存货发放明细
selectfrommtl_txn_request_lines--------请求
selectfrommtl_material_transactions_temp
selectfrommtl_transaction_types------物料处理类型
selectfrompjm_unit_numbers_lov_v
selectfrommtl_sales_orders----------------销售订单
selectfrommtl_secondary_inventories---------
selectfrommtl_lot_numbers----------
selectfrompjm_tasks_v
selectfrompjm_projects_v
selectfrompjm_project_parameters
selectfromfnd_user--------------系统用户
selectfrommtl_txn_request_headers-------------头
selectfrommtl_txn_request_lines------------体
selectfrommtl_onhand_quantities_detail----物料的库存明细--------
selectfromfnd_folders------------
selectfrommtl_item_sub_inventories
selectfrommtl_kanban_cards-------物料看板
selectfrommtl_physical_inventories_v------物理库存
selectfrommtl_category_sets_vl---物料类别
selectfrommtl_system_items_vl
selectfrommtl_txn_source_types
selectfrommtl_transaction_types---处理类型
selectfromorg_organization_definitions------库存组织whereor
selectfrommtl_item_status-----物料状态
selectfrommtl_employees_current_view------员工
selectfrompo_suppliers_val_v--------------采购供应商视图
selectfrommtl_employees_view-----------------员工
selectfrommtl_transaction_lots_temp
selectfrompa_projects_expend_v
selectfrompa_tasks_expend_v
selectfrompa_organizations_expend_v
selectfrommtl_onhand_quantities_detail---------物料现存量明细
selectfrommtl_lot_numbers----物料批号
selectfrommtl_transaction_reasons------------物料处理原因
selectfrommtl_item_uoms_view--------------物料单位mtl_units_of_measure
selectfrommtl_so_rma_interface
selectfrommtl_system_items------------物料项
selectfrommtl_item_sub_ast_trk_val_v
selectfrommtl_lot_issues_val_v-------------批次-
selectfrommtl_so_rma_interface
selectfrommtl_sub_ast_trk_val_v---------------子库
selectfrompa_expenditure_types
selectfromMTL_TXN_REQUEST_LINES_V--------------发送请求
selectfromMTL_SERIAL_NUMBERS_TEMP
selectfromMTL_TRANSACTION_LOTS_TEMP
selectfromMTL_MATERIAL_TRANSACTIONS_TEMP
selectfromMTL_ITEM_LOCATTIONS---------------货位
SelectfromPo_Requisition_Headers_all------------请购单头表
SelectfromPo_Requisition_lines_all----------体表
SelectfromPO_HEADER_ALL---------采购订单头
SelectfromPO_LINES_ALL---采购订单体
selectfromwsh_pick_slip_v
selectfrommtl_system_items_vlmsi--bug#3306781
selectfromwsh_delivery_detailswdd
selectfrommtl_txn_request_linesmtrl
selectfrommtl_txn_request_headersmtrh
selectfromwsh_delivery_assignmentswda
selectfromwsh_new_deliverieswnd
selectfromoe_order_lines_alloola
selectfromoe_setsos
selectfromwsh_pick_grouping_ruleswpgr
selectfromhz_locations-------交货位置表
selectfromhr_locations_all-------收貨位置表
Selectflex_value_set_idFromapps.fnd_flex_value_sets
selectfromMTL_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
FROMMTL_TXN_REQUEST_LINES_V
WHEREorganization_id=''117''AND-1=-1
and(mtl_txn_request_lines_v.move_order_type!=6
ANDmtl_txn_request_lines_v.request_numberbetween''4009''AND''4009''
ANDmtl_txn_request_lines_v.line_statusin(3,7,9))and(REQUEST_NUMBER=''4009'')
orderbyREQUEST_NUMBER,MOVE_ORDER_TYPE_NAME,LINE_NUMBER
------哪个用户锁定了哪个表的SQL----
SELECTc.owner
,c.object_name
,c.object_type
,fu.user_namelocking_fnd_user_name
,fl.start_timelocking_fnd_user_login_time
,vs.module
,vs.machine
,vs.osuser
,vlocked.oracle_username
,vs.SID
,vp.pid
,vp.spidASos_process
,vs.serial#
,vs.status
,vs.saddr
,vs.audsid
,vs.process
FROMfnd_loginsfl
,fnd_userfu
,v$locked_objectvlocked
,v$processvp
,v$sessionvs
,dba_objectsc
WHEREvs.SID=vlocked.session_id
ANDvlocked.object_id=c.object_id
ANDvs.paddr=vp.addr
ANDvp.spid=fl.process_spid(+)
ANDvp.pid=fl.pid(+)
ANDfl.user_id=fu.user_id(+)
--ANDc.object_nameLIKE''%''||UPPER(''&tab_name_leaveblank4all'')||''%''
ANDNVL(vs.status
,''XX'')!=''KILLED'';
--------------
selectfromoe_ra_cust_trx_hdr_v
selectfromar_payment_schedules_all
selectfromoe_ra_customers_v-----------客户名称
selectfromOE_PO_REQUISITION_LINES_V
------------==================
select
fyhzt.delivery_detail_id,
fyhzt.source_codeas源单类,
fyhzt.source_line_idas源单行号,
fyhzt.source_header_idas源单头号,
fyhzt.header_numberas单据号,
fyhzt.line_numberas行号,
fyhzt.ship_method_codeas发运方式,
fyhzt.inventory_item_idas物料ID,
fyhzt.requested_quantityas请求数量,
fyhzt.shipped_quantity_uomas发运单位,
fyhzt.shipped_quantityas已发运,
fyhzt.requested_quantity_uomas请求单位,
fyhzt.ship_set_id,
fyhzt.line_numberas批次号,
fyhzt.serial_numberas序列号从,
fyhzt.pick_statusas挑库状态,
fyhzt.pick_meaningas挑库状态名称,
fyhzt.delivery_id,
fyhzt.delivery_name,
fyhzt.delivery_status,
fyhzt.delivery_status_meaningas发运状态,
fyhzt.organization_idas公司,
fyhzt.initial_pickup_location_idas地点ID,
fyhzt.initial_pickup_locationas地点,
fyhzt.ultimate_dropoff_location_id,
fyhzt.ultimate_dropoff_location,
fyhzt.date_shipped,
fyhzt.date_received,
fyhzt.to_serial_numberas序列号止
fromWSH_DELIVERY_LINE_STATUS_Vfyhzt-------发运行状态
-------------------------
selectfromOE_ORDER_HEADERS_V
-------付款方式
selectdistinctt.name,t.descriptionfromra_termstorderbyt.name
--------收单地点
selectfromhz_cust_site_uses_all
-------业务员
selectfromJTF_RS_DEFRESOURCES_VL
-----------公司名称
selectfromHR_ALL_ORGANIZATION_UNITSwhereorganization_id=103
|
|