Useful Table
NewProgramer
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. ¿â´æ×éÖ¯£¬ÀýÈçÖÆÔìÉ̵IJֿ⣬ÀýÈç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 ¨C RECEIVING
A2.ACCEPT ¨C RECEIVING
A3.DELIERY ¨C 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