PROCEDURE main ( errbuff OUT NOCOPY VARCHAR2, retcode OUT NOCOPY VARCHAR2, p_file_name IN VARCHAR2 ) IS BEGIN start_process (p_file_name); — write_output; EXCEPTION WHEN OTHERS THEN NULL; END; PROCEDURE start_process (p_filename…
Read MoreSELECT DISTINCT aiha.invoice_id, response, aiha.creation_date, ai.invoice_date, (SELECT vendor_name FROM apps.po_vendors WHERE vendor_id = ai.vendor_id) vendorname, (SELECT ai.invoice_num FROM ap_invoices_all ai WHERE ai.invoice_id = aiha.invoice_id) invoice_number, (SELECT ai.invoice_amount FROM ap_invoices_all ai…
Read MoreDECLARE lc_uom VARCHAR2 (5); lc_cust_account_id NUMBER; lc_list_type_code VARCHAR2 (150); lc_list_line_type_code VARCHAR2 (150); lc_prod_attr_value VARCHAR2 (25); lc_segment_mapping_column VARCHAR2 (150); lc_prc_context_name VARCHAR2 (150); lc_prc_mapping_column VARCHAR2 (150); lc_prcing_context_name VARCHAR2 (150); lc_account_number VARCHAR2 (15);…
Read MoreSELECT SUM (target_qty) FROM (SELECT segment1, description, mtl.primary_uom_code, moqv.subinventory_code subinv, moqv.inventory_item_id item_id, SUM (transaction_quantity) target_qty FROM apps.mtl_onhand_qty_cost_v moqv, apps.mtl_system_items_vl mtl WHERE moqv.organization_id = :p_organization_id AND moqv.inventory_item_id = :p_inventory_item_id AND moqv.inventory_item_id…
Read MoreWhen there is a business requirement to create a New modifier, we can make use of this code to Register as a Concurrent Program and create a new Modifier after…
Read MoreOracle Payments provides the IBY_FD_EXTRACT_EXT_PUB extensibility package to construct custom XML element structure that can be added to the payment XML extract generated by Oracle Payments. If there is…
Read Moredeclare ln_trx_number VARCHAR2 (50); v_api_version NUMBER := 1.0; — V_init_msg_list VARCHAR2(1) := FND_API.G_FALSE; v_init_msg_list VARCHAR2 (1) := fnd_api.g_true; v_commit VARCHAR2 (1) := fnd_api.g_false; v_validation_level …
Read Moreexec mo_global.set_policy_context(‘S’,:&p_org_id); SELECT DISTINCT gjb.NAME journal_batch_name, gjh.NAME, gjh.default_effective_date gldate, msi.segment1 item, NULL brand, rct.bill_to_site_use_id bill_to_site_use_id, hca.account_number customer, gcc.segment3 “GL ACCT 3”, gcc.segment1 company, rct.interface_header_attribute2 ordertype, rctt.NAME ar_transaction_type, rctl.sales_order order_number, rct.trx_number…
Read More