Others

1. First introduce fndconc. PLL in Form 2. Call the request and wait until the request is completed.CodeAs follows: Procedure btn_click (p_btn_name varchar2) isX_req_id number;Rochelle phase_code varchar2 (1 );Rochelle status_code varchar2 (1 );

WIP-> discrete-> Discrete Task Task kevin13: information of all components in this ticket: Select MSI. segment1,MSI. description,WDJ. class_code,WDJ. status_type,WDJ. start_quantity,Wdj.net _ quantity,WDJ. quantity_completed,WDJ.

[Code] fnd_profile.value usage:   Select fnd_profile.value ('Gl _ set_of_books_id ')From dual   Select fnd_profile.value ('mfg _ organization_id ')From dual -- Get sub-database   Select fnd_profile.value ('Gl _ set_of_bks_id ')From dual -

Select AIA. invoice_num, AILA. line_number, AIA. invoice_id, PHA. segment1 po_number, PV. vendor_name, PV. segment1 supplier_num, PHA. currency_code, Pla. line_num, PLLA. shipment_num, Pla. item_description, Pla. unit_price, PLLA. quantity, PLLA.

Send an email with utl_smtp Ora-29278: SMTP temporary error: 421 service not available Ora-06512: In "SYS. utl_smtp", line 17 .... This error is not generated by the database server, but is returned from the SMTP server when SMTP cannot be found.

It can solve the problem of enabling pseudo-static in shopex. The message "your server is not Apache and cannot use the htaccess file. Enable rewrite manually. Otherwise, the system will automatically jump to the pseudo-static state after 10

Module: WIP Related table: Inv. mtl_material_transactions Material Transaction Processing table (transaction_source_id is connected to We. wip_entity_id) Inv. mtl_transaction_lot_numbers table of batch numbers for Material Transaction

Variables The core module supports built-in variables, whose names correspond with the names of variables in Apache. First of all, there are the variables, which represent the lines of the title of the client request, for example, $

From standard form, handling ticket   /* Procedure get_proj_cost_acc_segments is */DeclareRochelle segments fnd_flex_ext.segmentarray;Rochelle no_segments number;Rochelle concat_segs varchar2 (2000 );Rochelle get_flex Boolean;Begin-- Message

One problem found: In the form attribute, the first navigation block has been set to line block, and the block order is that the header block is placed below the line block. At this time when saving, first trigger the PRE-INSERT of line block, and

ERP software generally has a variety of cost accounting methods to choose from, usually divided into two categories: Standard Cost Method and actual cost method. The actual cost method is generally divided into the moving weighted average method,

The consultant life while working at client site is not easy during ERP transformation projects, please times it's required to provide some Adhoc query for extract to ends users, therefore it is important to have a cheat sheet so that such untimely

1. application environment:12.0.6 2. Business Requirements:Some products add an indicator (TEST) in the production process according to the special order, resulting in a relatively large variation with the actual working hours, and decide to enable

Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--> Select gjl. je_header_id, Gjl. je_line_num, Gjh. je_source, Gjh. name, Gjh.doc _ sequence_value, Xag. third_party_id vendor_id, Xag. third_party_

In ap_invoice_distributions_all, rcv_transaciton_id is null and sometimes has a value. Why? (See po_line_locations_all. Match_option) Maybe you still remember that when we select a Match on the invoice workbench, sometimes it is a Match PO,

Call Oe_Order_Pub.process_order Update and Insert record   1, Scope of use Process Order can Update, Insert, and Delete the following sales Order entities    Entity Table NameOrder Header OE_ORDER_HEADERS_ALL Order Price Adjustments

1. Purpose: To use the API to obtain the payment conditions for the transactions to be processed (the payment conditions and expiration dates for implementing standard functions) 2. Implementation Method: Call ARP_TRX_DEFAULTS_3.get_term_default to

Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->/* OEXOEFRM OE_OEXOEMOE.Key_Commit; */ Declare Rochelle header_rec oe_order_pub.header_rec_type; Rochelle line_tbl oe_order_pub.line_tbl_type; Rochelle

  Create a project based on the API /*************************************** **************************************** *********Created By: COOLER LEE Creation Date: 2006-1-4 Notes: Please uncomment the dbms_output statements if needed.This is being

Executable: ITEM_PRICE_UPT Short Name: ITEM_PRICE_UPT Application: XX Description: Execution Method: SQL * Loader Execution File Name: ITEM_PRICE_UPT Subroutine Name: Execution File Path: Excel file: PUR_PRICE_UPT.csv FTP upload