How to compile CUSTOM.pll in R12 July 28, 2018 Step1: Goto AU_TOP/resource cd $AU_TOP/resource Step2: Execute the below command. frmcmp_batch module=CUSTOM.pll userid=apps/<apps password> output_file=CUSTOM.plx module_type=LIBRARY batch=yes compile_all=special Share Get link Facebook X Pinterest Email Other Apps Labels compile Custom Pll Share Get link Facebook X Pinterest Email Other Apps Comments
API to Create & Update Price Adjustment and Order Lines April 29, 2015 Important Tables: select header_id from oe_order_headers_all; select line_id from oe_order_lines_all; select list_header_id from qp_list_headers_all; select list_line_id from qp_list_lines; CREATE OR REPLACE PROCEDURE apps.xxapply_discount (p_header_id number) IS v_api_version_number number := 1; v_return_status varchar2 (2000); v_msg_count number; v_msg_data varchar2 (2000); -- in variables -- v_header_rec oe_order_pub.header_rec_type; v_line_tbl oe_order_pub.line_tbl_type; v_action_request_tbl ... Read more
Uninvoiced Receipts Query Oracle r12 August 05, 2019 Uninvoiced Receipts: SELECT pha.segment1 po_number, TO_CHAR (pha.creation_date, 'DD-MON-RRRR') po_date, (SELECT vendor_name FROM ap_suppliers ap WHERE ap.vendor_id = pha.vendor_id) supplier_name, pla.quantity, pla.unit_price, pla.quantity * pla.unit_price AS line_amount, (SELECT concatenated_segments FROM gl_code_combinations_kfv gcc WHERE gcc.code_combination_id = pda.code_combination_id) charge_account, rsh... Read more
Comments
Post a Comment