360doc--lucienwan的文章 http://www.ahfyzs.com/rssperson/11476579.aspx 360doc (http://www.ahfyzs.com) zh-cn 360doc--個(gè)人圖書館 FORM開發(fā)相關(guān)技術(shù)(三) http://www.ahfyzs.com/content/12/0927/00/8744774_238369408.shtml 2013/10/13 22:39:23

1.打開windows--修改PER-FORM觸發(fā)器中調(diào)用第一個(gè)form--修改app_custo.open_window中調(diào)用windows的名字，打開窗口（用鍵盤切換當(dāng)前Block或用button打開窗體時(shí)，需使用APP_CUSTOM.OPEN_WINDOW函數(shù)，語法為APP_CUSTOM.OPEN_WINDOW（‘block_name’）APP_CUSTOM.OPEN_WINDOW 中又會(huì)調(diào)用app_window.set_window_position。

Oracle 函數(shù) Translate 的用法 http://www.ahfyzs.com/content/13/0129/16/11476579_263062674.shtml 2013/1/29 16:00:11

Oracle 函數(shù) Translate 的用法。select translate(''abcbbaadef'',''ba'',''#@'') from dual （b將被＃替代，a將被＠替代）select translate(''abcbbaadef'',''bad'',''#@'') from dual?。╞將被＃替代，a將被＠替代，d對應(yīng)的值是空值，將被移走）因此：結(jié)果依次為：@#c##@@def 和@#c##@@ef語法：TRANSLATE(expr,from,to)expr: 代表一串字符，from 與 to 是從左到右一一對應(yīng)的關(guān)系，如果不能對應(yīng)，則視為空值。

Oracle ERP 倉庫(inventory) 詞匯 http://www.ahfyzs.com/content/13/0123/16/11476579_261971268.shtml 2013/1/23 16:27:50

例如，在對某物料執(zhí)行采購訂單接收時(shí)，如果物料定義了物料間接費(fèi)用分?jǐn)偮?，則需要按物料間接費(fèi)用成本借記庫存估價(jià)帳戶、貸記物料間接費(fèi)用吸收帳戶，以便將費(fèi)用從總帳帳戶“吸收”至庫存。ATO 請參閱：按訂單裝配ATO item（ATO 物料）請參閱：按訂單裝配物料ATO model（ATO 模型）請參閱：按訂單裝配模型ATP（可承諾量）ATP（可承諾量）通常指根據(jù)當(dāng)前和計(jì)劃的物料供應(yīng)報(bào)表對成品可用性進(jìn)行承諾的能力。

Oracle EBS 11i 表結(jié)構(gòu)——PO模塊 http://www.ahfyzs.com/content/13/0121/13/11476579_261541452.shtml 2013/1/21 13:21:24

How to enter a Receipt (Receive/Deliver Transactions) for a Standard Purchase Order via the Receivin http://www.ahfyzs.com/content/13/0117/10/11476579_260672588.shtml 2013/1/17 10:45:40

TRANSACTION_INTERFACE_ID=11599958LOT_NUMBER=B00406SERIAL_TRANSACTION_TEMP_ID=11599958PRODUCT_CODE=RCVPRODUCT_TRANSACTION_ID=576924.SQL> Select * from RCV_HEADERS_INTERFACE where HEADER_INTERFACE_ID=&Header_Interface_IDGROUP_ID=32140HEADER_INTERFACE_ID=180194PROCESSING_STATUS_CODE=SUCCESSRECEIPT_HEADER_ID=594567VENDOR_ID=7927VALIDATION_FLAG=YPROCESSING_REQUEST_ID=3053037.

OracleERP-庫存管理 http://www.ahfyzs.com/content/13/0116/15/11476579_260529262.shtml 2013/1/16 15:43:36

而庫存事務(wù)處理則以子庫存為中心，要么從某個(gè)子庫存出，要么從某個(gè)子庫存入；事務(wù)處理是物品進(jìn)、出庫存或在倉庫內(nèi)或者組織間移動(dòng)，即倉庫的日常收發(fā)業(yè)務(wù)處理事務(wù)處理會(huì)引起物品數(shù)量，位置或成本的變化庫存事務(wù)有多種，有系統(tǒng)提供的，也可由客戶根據(jù)實(shí)際情況需要定義每一種物品交易時(shí)系統(tǒng)會(huì)產(chǎn)生對應(yīng)的財(cái)務(wù)記錄可以通過版本號、批號、系列號，貨位來對有關(guān)項(xiàng)目進(jìn)行跟蹤/控制物品的事務(wù)處理可以與相關(guān)的項(xiàng)目（Project）進(jìn)行關(guān)聯(lián)。

po receiveing http://www.ahfyzs.com/content/13/0115/18/11476579_260356815.shtml 2013/1/15 18:15:39

LOCATION_ID Number Conditionally PO, ASN, REQ,INV, RMAPO/ASN=Varchar2(25) Optional PO, ASN, REQ,INV, RMAPACKING_SLIP Varchar2(25) Optional PO, ASN, REQ,INV, RMASHIPPED_DATE Date Optional PO, ASN, REQ,INV, RMAFREIGHT_CARRIER_CODEVarchar2(25) Optional PO, ASN, REQ,INV, RMAEXPECTED_RECEIPT_DATEDate Yes PO, ASN, REQ,INV, RMARECEIVER_ID Number Optional PO, ASN, REQ,INV, RMANUM_OF_CONTAINERS.

Oracle -RMA Sales Order http://www.ahfyzs.com/content/13/0115/14/11476579_260307554.shtml 2013/1/15 14:38:27

Oracle -RMA Sales OrderOracle -RMA Sales Order.What is RMA?A: Receipt Routing for RMA receipts is determined based on acombination of the Item Attribute of ''RMA Inspection Required'' andthe value of Receiving Option ''RMA Receipt Routing''.Also, if the RMA line refers to asales order line with serialized items, there is no validationagainst the serial numbers shipped on the sales order line.

Technical components of Oracle Purchasing http://www.ahfyzs.com/content/13/0115/14/11476579_260300226.shtml 2013/1/15 14:04:26

BLANKET_PO_HEADER_ID and BLANKET_PO_LINE_NUM store the suggested blanket purchase agreement or catalog quotation line information for the requisition line.For each organization, there are four rows for each of the following entities: PO_HEADERS_ALL, PO_REQUISITION_HEADERS_ALL, PO_HEADERS_RFQ and PO_HEADERS_QUOTE. There are two rows corresponding to the entities PO_VENDORS and RCV_SHIPMENT_HEADERS.

http://blog.csdn.net/pan http://www.ahfyzs.com/content/13/0115/10/11476579_260258879.shtml 2013/1/15 10:35:37

路徑：Purchasing >Requisitions >Requisitions.PO_REQUISITION_LINES。Receipt成功運(yùn)行之后，可以看到RTI的數(shù)據(jù)被刪除，RCV的相關(guān)數(shù)據(jù)也會(huì)生成在rcv_shipment_headers,rcv_shipment_lines,rcv_transactions,rcv_supply表中，rcv_shipment_headers記錄了Receipt Header的信息，rcv_shipment_lines記錄了Receipt的Line的信息，RT為接收的歷史表，RCV_SUPPLY標(biāo)識了還有多少待接收數(shù)量（這個(gè)時(shí)候SUPPLY_TYPE_CODE為RECEIVING狀態(tài)）。

R12 WEBADI 開發(fā)實(shí)例 (EBS 版本：12.1.3) http://www.ahfyzs.com/content/13/0113/12/11476579_259890100.shtml 2013/1/13 12:37:57

FOR rec_xla_ac IN c_xla_ac(rec_xla_je.ae_header_id, rec_xla_je.ae_line_num) LOOP IF rec_xla_ac.analytical_criterion_code = ''C_GBL_QUANTITY'' THEN vl_quantity := rec_xla_ac.ac1;FOR rec_xla_je_period IN c_xla_je_period LOOP FOR rec_xla_je IN c_xla_je(rec_xla_je_period.ae_header_id) LOOP vl_quantity := NULL;