Posts by Brahmaiah kolla

Adding new row at bottom of the where have clicked Through OAF

public void processFormRequest(OAPageContext pageContext, OAWebBean webBean) { super.processFormRequest(pageContext, webBean); OAApplicationModule am=(OAApplicationModule)pageContext.getApplicationModule(webBean); OAViewObject vo = (OAViewObject)am.findViewObject(“XXAddRowVO1″); String refpono=””; if(“AddRowEvent”.equals(pageContext.getParameter(“event”))) { int rs=0; String rowRef1 = pageContext.getParameter(“evtSrcRowRef”); OARow Porowref = (OARow)am.findRowByRef(rowRef1); refpono=Porowref.getAttribute(“Segment1”).toString();…

Read More

Deleting Lines based on conditions through OAF

if (“DeleteEvent”.equals(oapagecontext.getParameter(“event”))) { String rowReference = oapagecontext.getParameter(EVENT_SOURCE_ROW_REFERENCE); OARow currRow = (OARow)oaapplicationmodule.findRowByRef(rowReference); String QuantityShipped =(new StringBuilder()).append(currRow.getAttribute(“QuantityShipped”)).append(“”).toString(); System.out.println(“QuantityShipped in DeleteEvent”+QuantityShipped); if(QuantityShipped.equals(“null”)) { currRow.remove(); oadbtransaction.commit(); throw new OAException(“Record Sucessfully Deleted”, OAException.CONFIRMATION); } else…

Read More

Calling Concurrent Program in OAF

public void submitRequestPKS(OAPageContext oapagecontext, OAWebBean oawebbean, String s, String s1) { OAApplicationModule oaapplicationmodule = oapagecontext.getApplicationModule(oawebbean); OAException oaexception; try { OADBTransaction oadbtransaction = oaapplicationmodule.getOADBTransaction(); Connection connection = oadbtransaction.getJdbcConnection(); ConcurrentRequest concurrentrequest =…

Read More

Invoice Details by using Netting tables

SELECT AI .INVOICE_ID, AI.INVOICE_NUM, TO_CHAR ( AI.INVOICE_AMOUNT + (SELECT NVL (SUM (amount), 0) FROM ap_invoice_lines_All WHERE invoice_id = AI.INVOICE_ID AND LINE_TYPE_LOOKUP_CODE = ‘AWT’), FND_CURRENCY_CACHE.GET_FORMAT_MASK (AI.INVOICE_CURRENCY_CODE, 30) ) invoice_amount, AI.INVOICE_DATE, TO_CHAR…

Read More

Query For PO Acceptance Details

SELECT DISTINCT pha.vendor_id, hou.name “Organization”, pha.segment1 “po number”, pla.line_num “po line num”, (TRUNC (pha.creation_date – TO_DATE (’01-01-1900′, ‘DD/MM/YYYY’)) + 2) as “PO creation Date”, aps.vendor_name “Supplier Name”, apss.vendor_site_code “Supplier site”,…

Read More

Eligible Po Details for Supplier Wise

SELECT * FROM (SELECT POH.SEGMENT1 PO_NUMBER, PRL.RELEASE_NUM RELEASE_NUM, DECODE ( PRL.PO_RELEASE_ID, NULL, POH.clm_document_number, POH.clm_document_number || ‘-‘ || TO_CHAR (PRL.RELEASE_NUM) ) DISPLAY_PO_NUMBER, POL.LINE_NUM LINE_NUM, POL.ITEM_ID ITEM_ID, POL.ITEM_REVISION ITEM_REVISION, POL.ITEM_DESCRIPTION ITEM_DESCRIPTION, POL.VENDOR_PRODUCT_NUM…

Read More

Advance Shipment Notice details Query.

SELECT DISTINCT RHI.SHIPMENT_NUM, RHI.SHIPPED_DATE, RHI.EXPECTED_RECEIPT_DATE, RHI.FREIGHT_CARRIER_CODE, RHI.INVOICE_NUM, RHI.WAYBILL_AIRBILL_NUM, RHI.NUM_OF_CONTAINERS, RHI.FREIGHT_TERMS, RHI.BILL_OF_LADING, RHI.PACKING_SLIP, RHI.PACKAGING_CODE, POV.VENDOR_NAME, POV.SEGMENT1 VENDOR_NUMBER, PVS.VENDOR_SITE_CODE, RHI.SPECIAL_HANDLING_CODE, RHI.TAR_WEIGHT, RHI.TAR_WEIGHT_UOM_CODE, RHI.NET_WEIGHT, RHI.NET_WEIGHT_UOM_CODE, RHI.COMMENTS, ” CANCELLATION_STATUS, ” PROCESSING_STATUS, RHI.VENDOR_ID, RHI.VENDOR_SITE_ID, NULL…

Read More