【转载】ORACLE EBS常用表

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

原文地址:http://www.cnblogs.com/lfx0692/articles/2395574.html 

共有 18 条评论

Top