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 [...]

Introduction: User wants to pull the Open Purchase order details data. Solution: We provide the view to fulfill their requirement. View: CREATE OR REPLACE VIEW [...]

DECLARE 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 [...]

create 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 ( [...]

SELECT ( SELECT organization_name FROM org_organization_definitions WHERE organization_id = msi.organization_id ) org_name, msi.segment1 item_number, msi.description item_description, [...]

SELECT gjjlv.period_name “Period Name”, gjb.name “Batch Name”, gjjlv.header_name “Journal Entry For”, gjjlv.je_source “Source”, gjjlv.je_category [...]

create 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 [...]

create 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 [...]

SELECT 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 [...]

SELECT 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 [...]