The below is the query to get all the invoices on hold for a particular operating unit. SELECTpo.comments po_notes,pf1.full_name buyer,ah.hold_date,ah.hold_lookup_code,(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 requisition_num,po.segment1…
Read MoreObjective. The objective of the below API is used to increase the onhand quantity in Inventory through Miscellaneous Receipt. Sample Code. set serveroutput on declare l_api_version NUMBER := 1.0; l_init_msg_list…
Read MoreThe below is the query for AR Transaction Register details at Distribution Level SELECT RCTL.CUSTOMER_TRX_line_ID, hou.name ou_name, c.account_number “Customer Number”, ( SELECT party_name FROM apps.hz_parties WHERE party_id = c.party_id )…
Read MoreThe below is the query for AR Transaction Register Summary Report at Line Level SELECT hou.name ou_name, c.account_number “Customer Number”, ( SELECT party_name FROM apps.hz_parties WHERE party_id = c.party_id…
Read MoreUsing the below query we can track the DML operations made on Supplier’s.It is useful script for Auditing and Tracking purposes. select DISTINCT a.segment1 vendor_number,A.VENDOR_NAME,c.name org_name,a.creation_date supplier_creation_date, (select user_name…
Read MoreOverview: Below query give the form personalization details. Query: SELECT DISTINCT a.ID, a.SEQUENCE, a.function_name, a.form_name, a.enabled, c.user_form_name, d.application_name, a.description, a.trigger_event, a.trigger_object, a.condition, ca.* FROM fnd_form_custom_rules a, fnd_form b, fnd_form_tl…
Read MoreObjective: Populate TDS Tax Category for multiple lines through the custom procedure for an invoice before doing the validation and at the time of Action button clicked. Seq 10 Description…
Read MoreRequirement Single Excel column output with multiple data separated by comma need to make row-wise data, eg Name Marks Peter 50,70,30 Need to change with this Name Marks Peter 50…
Read MorePlease find below query to get customer Bill_To Address SELECT DECODE (hcsua.site_use_code, ‘BILL_TO’, hl.address1 || ‘, ‘ || hl.address2 || ‘, ‘ || hl.city || ‘, ‘ || hl.state…
Read MoreAPI “AP_AI_TABLE_HANDLER_PKG.DELETE_ROW” can be used to delete AP Invoice Data. This Script can be used when invoice accounting is not done. DECLARE CURSOR CUR1 IS SELECT AIA.ROWID,AIA.* FROM AP_INVOICES_ALL…
Read More