Posts by Meena Desappan

Query to extract modifiers have been applied to a particular sales order

oracle-ebs-modifier-applied-against-so SELECT a.NAME “Modifier Name”,b.INVENTORY_ITEM_ID, b.list_line_no “Modifier Line No”, a.description “Modifier Description”, a.comments, b.list_line_type_code, d.qualifier_context, a.orig_org_id, a.active_flag, b.start_date_active, b.end_date_active, a.list_type_code, b.modifier_level_code, b.organization_id, f.order_number, b.pricing_phase_id, b.last_update_date, b.list_line_no, d.header_quals_exist_flag, d.qualifier_datatype, d.qualifier_attribute, d.segment_id,…

Read More

Query to extract payment terms associated with a customer

oracle-ebs-customer-payment-terms SELECT customer_name, site_use_code, location, payment_term_id, name   FROM apps.hz_cust_site_uses_all a1,        hz_cust_acct_sites_all a2,        ar_customers a3,        ra_terms a4  WHERE a1.cust_acct_site_id = a2.cust_acct_site_id    AND a2.cust_account_id = a3.customer_id   …

Read More

Query to generate file in remote server when new record inserted into table.

oracle-ebs-query-to-generate-file-in-remote-server-when-new-record-inserted-into-table Script 1: CREATE OR REPLACE DIRECTORY XDMC_OUTBOUND AS ‘XX_TEST/outbound/CUST_PO’; / Script 2: CREATE OR REPLACE PROCEDURE APPS.XDMC_PO_FILE_GEN( p_cust_po_number IN VARCHAR2, p_status OUT NOCOPY VARCHAR2 ) AS v_file UTL_FILE.FILE_TYPE; lc_filedir        …

Read More

Query to Find Form Responsibility in Oracle E-Business Suite (EBS)

query-to-find-form-responsibility-in-oracle-e-business-suite-ebs Query 1: SELECT function_id,USER_FUNCTION_NAME, FUNCTION_NAME, form_name FROM fnd_form_functions_vl fff, fnd_form ff WHERE fff.form_id = ff.form_id and form_name=’OEXOEORD’ Query 2: SELECT responsibility_name, menu_structure.PATH navigation FROM (           SELECT LEVEL padding, menu_id,…

Read More