We will be discuss about the api to update vendor payment terms update in ap_suppliers. This is the standard API to update vendor details in ap_suppliers. ========================================================================== Step1:- Create the…
Read MoreThis document explain how to deactivate supplier through API. SET serveroutput on; DECLARE p_api_version NUMBER; p_init_msg_list VARCHAR2(200); p_commit VARCHAR2(200); p_validation_level NUMBER; x_return_status VARCHAR2(200); x_msg_count NUMBER; x_msg_data VARCHAR2(200); lr_vendor_rec apps.ap_vendor_pub_pkg.r_vendor_rec_type; lr_existing_vendor_rec ap_suppliers%ROWTYPE; l_msg VARCHAR2(200); p_vendor_id NUMBER; BEGIN — Initialize apps session fnd_global.apps_initialize(1234, 50833, 200); mo_global.init(‘SQLAP’);…
Read MoreThis query will extract the PO amendment details for the revised PO’s SELECT po_number, po_date, approved_date, buyer_name, revision_number,po_header_description, amendment_by, amendment_date,CASE when (((NVL(old_price,-1)NVL(new_price,-1)) and old_price is not null) and ((NVL(old_quantity,-1)NVL(current_qty,-1)) and…
Read MoreThe query gives the onhand quantity details with serial number and locator details select ohd.item,ohd.item_desc,ohd.org_code,ohd.org_name,ohd.sub_inventory,ohd.locator,msn.serial_number,ohd.item_status,ohd.uom,NVL2(msn.serial_number,1,ohd.total_onhand_qty) onhand_qty,ohd.total_onhand_qty,ohd.total_reserve_qty,ohd.total_transact_qty,mmt.transaction_date stock_in_date,mst.transaction_source_type_name stock_in_typefrom (SELECT msi.inventory_item_id , (select max(mq.create_transaction_id) from mtl_onhand_quantities mqwhere 1=1and mq.organization_id = moq.organization_idand…
Read MoreThe query provides the item dispatch details information of the sales order SELECToola.line_number,oola.line_id,ooha.orig_sys_document_ref ,ooha.order_source_id,ooha.order_number sale_order_no,trunc(ooha.ordered_date) sale_order_date,hp_ship.party_name customer_name,–hl_ship.address1,hcs_ship.location customer_site,ooha.cust_po_number customer_po_ref,rct.trx_number customer_invoice_num,rct.trx_date invoice_date,msib.segment1 item_code,msib.description item_desc,oola.shipping_quantity qty,oola.order_quantity_uom uom,ms.serial_number serial_num,mth.request_number move_order_ref,trunc(actual_shipment_date) shipment_dateFROMoe_order_headers_all ooha,oe_order_lines_all oola,mtl_system_items_b…
Read MoreThis package will explode BOM details at all levels of a Finished Good and write the data to a file in the Directory CREATE OR REPLACE PACKAGE XX_FINISHED_GOOD_BOM_PKG AS PROCEDURE…
Read MoreSELECT msi.segment1 “Parent material coding”,msi.inventory_item_id,msi.description “Parent item description”,msi1.segment1 “Sub item code”,msi1.inventory_item_id sub_item_id,msi1.description “Sub item description”FROM mtl_system_items_b msi,bom_bill_of_materials bom,bom_inventory_components bic,mtl_system_items_b msi1WHERE 1 = 1AND msi.organization_id = :organization_idAND msi.inventory_item_id = bom.assembly_item_idAND msi.organization_id…
Read MoreThe below are the steps to follow to develop a basic Custom form in EBS. Download the Resource folder from the server and place in local directory. Right Click on…
Read MoreWhen the tax profile is missing for a customer, we cannot edit the customer profile details from the Customer dashboard. So to identify such customers where we may face the…
Read MoreThe below is the query to get all the payments on hold for a particular operating unit. SELECTpo.comments po_notes,pf1.full_name buyer,ah.hold_flag paymnet_hold_flag,ah.amount_remaining,(SELECTuser_nameFROMapps.fnd_userWHEREuser_id = rh.created_by) requisition_created_by,(SELECTfull_nameFROMapps.per_all_people_fWHEREperson_id = rh.preparer_idAND ROWNUM = 1) preparer,rh.segment1…
Read More