Introduction: Requested to update the Tax code in customer Ship-to. Solution: We have update the Tax code by using the oracle API. API: DECLARE x_return_status VARCHAR2(10); l_init_msg_list VARCHAR2(1000) := FND_API.G_FALSE;…
Read MoreIntroduction: User wants to pull the Open Purchase order details data. Solution: We provide the view to fulfill their requirement. View: CREATE OR REPLACE VIEW “APPS”.”XDMC_OPEN_PO_DETAIL_V” (“BUYER”, “VENDOR_NO”, “VENDOR”, “SITE_NO”,…
Read MoreDECLARE CURSOR C1 IS SELECT (upper(A.item_code)) ITEM_CODE, A.ORGANIZATION_ID ORG_ID, A.sales_account FROM hs_item_sales_account_conv A WHERE A.ORGANIZATION_ID=111 AND A.ITEM_CODE IN() AND EXISTS (SELECT 1 FROM MTL_SYSTEM_ITEMS_B MSI WHERE MSI.ORGANIZATION_ID=111 AND MSI.SEGMENT1=(upper(A.item_code))); BEGIN…
Read Morecreate or replace PACKAGE xdmc_release_hold_pkg AUTHID CURRENT_USER AS PROCEDURE call_fnd_global ( p_user_id NUMBER, p_resp_id NUMBER, p_resp_appl_id NUMBER ); PROCEDURE xdmc_release_hold ( errbuf OUT VARCHAR2, retcode OUT NUMBER, p_order_number IN NUMBER…
Read MoreSELECT ( SELECT organization_name FROM org_organization_definitions WHERE organization_id = msi.organization_id ) org_name, msi.segment1 item_number, msi.description item_description, msi.primary_unit_of_measure, –msi.item_type, ( SELECT flv.meaning FROM apps.mtl_system_items_b msb, apps.fnd_lookup_values flv WHERE lookup_type = ‘ITEM_TYPE’…
Read MoreSELECT gjjlv.period_name “Period Name”, gjb.name “Batch Name”, gjjlv.header_name “Journal Entry For”, gjjlv.je_source “Source”, gjjlv.je_category “Category”, glcc.concatenated_segments “Accounts”, nvl(gjjlv.line_entered_dr,0) “Entered Debit”, nvl(gjjlv.line_entered_cr,0) “Entered Credit”, nvl(gjjlv.line_accounted_dr,0) “Accounted Debit”, nvl(gjjlv.line_accounted_cr,0) “Accounted Credit”, gjjlv.currency_code…
Read Morecreate or replace PROCEDURE xx_open_period ( errbuf OUT VARCHAR2, retcode OUT VARCHAR2, errmsg OUT VARCHAR2, p_from_org_id IN NUMBER, p_to_org_id IN NUMBER ) IS l_user_id NUMBER; l_resp_id NUMBER; l_appl_id NUMBER; l_org_id…
Read Morecreate or replace PROCEDURE XX_VALIDATE_DEBIT_INVOICE(errbuf OUT VARCHAR2, retcode OUT VARCHAR2, p_batch_run_id IN NUMBER, p_org_id IN NUMBER, P_stg_id IN NUMBER, p_debit_memo_num IN VARCHAR2) IS L_ORG_ID NUMBER:=p_org_id; L_SOB_ID NUMBER; L_USER_ID NUMBER; l_resp_id…
Read MoreSELECT glcc.concatenated_segments segments, gjl.period_name, gjh.name journal_name, gjb.name batch_name, gjh.je_source journal_source, gjh.je_category journal_category, glcc.segment1 entity_segment, glcc.segment2 project_segment, ffv.attribute1 project_vertical_dff, glcc.segment3, glcc.segment4, glcc.segment5, glcc.segment6, glcc.segment7, TO_CHAR(gjh.doc_sequence_value) gl_doc_no, TO_CHAR(gjh.default_effective_date,’DD-MON-YYYY’) gl_date, TO_CHAR(gjh.posted_date,’DD-MON-YYYY’) posted_date, xah.event_type_code…
Read MoreSELECT POV.VENDOR_NAME , AIA.INVOICE_TYPE_LOOKUP_CODE AS INVOICE_TYPE , AIA.INVOICE_NUM , AIA.INVOICE_DATE , AID.ACCOUNTING_DATE AS GL_DATE , AIA.INVOICE_CURRENCY_CODE , PHA.SEGMENT1 AS PO_NUMBER , RSH.RECEIPT_NUM , NVL(AIA.EXCHANGE_RATE,1) AS EXCHANGE_RATE , GCC.CONCATENATED_SEGMENTS , AID.AMOUNT…
Read More