Cloud Enterprise Contract Clause Query ============================ select ch.contract_number, cab.label||’ ‘||caa.article_title from okc_k_headers_vl ch,okc_k_articles_b cab,okc_articles_all caa, okc_article_versions cv where ch.id = cab.document_id and cab.article_version_id = cv.article_version_id and cv.article_id = caa.article_id
Read Moreselect hp.party_name customer_name, a1.account_number customer_number, a3.STATUS site_status, SITE_USE_CODE,LOCATION,PRIMARY_FLAG ,PARTY_SITE_NUMBER,A5.ADDRESS1,A5.ADDRESS2,A5.ADDRESS3,A5.ADDRESS4,A5.CITY,A5.POSTAL_CODE,A5.STATE,A5.COUNTRY from hz_cust_accounts a1,hz_cust_acct_sites_all a2, hz_cust_site_uses_all a3,HZ_PARTY_SITES A4,HZ_LOCATIONS A5, hz_parties hp where a1.CUST_ACCOUNT_ID=a2.CUST_ACCOUNT_ID and a1.party_id=hp.party_id and a2.CUST_ACCT_SITE_ID=a3.CUST_ACCT_SITE_ID and nvl(A1.STATUS,’A’)=’A’ and nvl(A3.STATUS,’A’)=’A’ AND A2.PARTY_SITE_ID=A4.PARTY_SITE_ID AND A4.LOCATION_ID=A5.LOCATION_ID
Read MoreGlobal Human Resources Views EEC_CONTEST_TEMPLATE_HDR_VL EEC_METRICS_VL EEC_REWARDS_VL HCM_EXTENDED_LOOKUP_CODES_VL HR_ALL_ORGANIZATION_UNITS HR_ALL_ORGANIZATION_UNITS_F_VL HR_ALL_ORGANIZATION_UNITS_TL HR_ALL_ORGANIZATION_UNITS_VL HR_ALL_ORGANIZATION_UNITS_X HR_ALL_POSITIONS HR_ALL_POSITIONS_F_VL HR_ALL_POSITIONS_X HR_BU_LOCATIONS_X HR_COMPANY_VS_V HR_COST_CENTER_VS_V HR_DOCUMENT_TYPES_VL HR_LEGAL_ENTITIES HR_LOCATIONS HR_LOCATIONS_ALL HR_LOCATIONS_ALL_F HR_LOCATIONS_ALL_F_VL HR_LOCATIONS_ALL_TL HR_LOCATIONS_ALL_VL HR_LOCATIONS_ALL_X HR_LOCATION_EXTRA_INFO HR_LOCATION_EXTRA_INFO_F…
Read MoreGlobal Human Resources Tables EEC_CONTEST_HDR EEC_CONTEST_METRIC_DETAILS EEC_CONTEST_PARTICIPANTS EEC_CONTEST_REWARDS EEC_CONTEST_STAGES EEC_CONTEST_TEMPLATE_DTL EEC_CONTEST_TEMPLATE_HDR_B EEC_CONTEST_TEMPLATE_HDR_TL EEC_CONTEST_UPDATES EEC_CONTEST_VOTERS EEC_CONTEST_VOTE_CAST EEC_CONTEST_WINNERS EEC_LB_CONTEST_DETAILS EEC_METRICS_B EEC_METRICS_TL EEC_REWARDS_B EEC_REWARDS_TL EEC_TEAM HCM_EXTENDED_LOOKUP_CODES_B HCM_EXTENDED_LOOKUP_CODES_TL HR_ALL_ORGANIZATION_UNITS_F HR_ALL_ORGANIZATION_UNITS_F_ HR_ALL_POSITIONS_F HR_ALL_POSITIONS_F_ HR_ALL_POSITIONS_F_TL HR_ALL_POSITIONS_F_TL_…
Read MoreSOLUTION Below are some sample payload for findCustomerAccountOperation: <soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:typ=”http://xmlns.oracle.com/apps/cdm/foundation/parties/customerAccountService/applicationModule/types/” xmlns:typ1=”http://xmlns.oracle.com/adf/svc/types/”> <soapenv:Header/> <soapenv:Body> <typ:findCustomerAccount> <typ:findCriteria> <typ1:fetchStart>0</typ1:fetchStart> <typ1:fetchSize>1</typ1:fetchSize> <typ1:filter> <typ1:conjunction/> <typ1:group> <typ1:conjunction/> <typ1:upperCaseCompare>false</typ1:upperCaseCompare> <typ1:item> <typ1:conjunction/> <typ1:upperCaseCompare>false</typ1:upperCaseCompare> <typ1:attribute>AccountNumber</typ1:attribute> <typ1:operator>=</typ1:operator> <typ1:value>GB000557</typ1:value> </typ1:item>…
Read More<soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:typ=”http://xmlns.oracle.com/apps/prc/poz/suppliers/supplierServiceV2/types/” xmlns:sup=”http://xmlns.oracle.com/apps/prc/poz/suppliers/supplierServiceV2/” xmlns:sup1=”http://xmlns.oracle.com/apps/flex/prc/poz/suppliers/supplierServiceV2/supplierSites/” xmlns:sup2=”http://xmlns.oracle.com/apps/flex/prc/poz/suppliers/supplierServiceV2/supplierAddress/” xmlns:sup3=”http://xmlns.oracle.com/apps/flex/prc/poz/suppliers/supplierServiceV2/supplier/” xmlns:sup4=”http://xmlns.oracle.com/apps/flex/prc/poz/suppliers/supplierServiceV2/supplierContact/”> <soapenv:Header/> <soapenv:Body> <typ:updateSupplier> <typ:supplierRow> <!–Optional:–> <sup:SupplierId></sup:SupplierId> <!–Optional:–> <sup:Supplier></sup:Supplier> <!–Optional:–> <sup:SupplierNew></sup:SupplierNew> <!–Optional:–> <sup:SupplierNumber>1538988727</sup:SupplierNumber> <!–Optional:–> <sup:AlternateName>SV supplier 01 updated</sup:AlternateName> <!–Optional:–> <sup:TaxOrganizationType></sup:TaxOrganizationType> <!–Optional:–> <sup:SupplierType></sup:SupplierType> <!–Optional:–>…
Read More<soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:typ=”http://xmlns.oracle.com/apps/prc/poz/suppliers/supplierServiceV2/types/” xmlns:sup=”http://xmlns.oracle.com/apps/prc/poz/suppliers/supplierServiceV2/” xmlns:sup1=”http://xmlns.oracle.com/apps/flex/prc/poz/suppliers/supplierServiceV2/supplierSites/” xmlns:sup2=”http://xmlns.oracle.com/apps/flex/prc/poz/suppliers/supplierServiceV2/supplierAddress/” xmlns:sup3=”http://xmlns.oracle.com/apps/flex/prc/poz/suppliers/supplierServiceV2/supplier/” xmlns:sup4=”http://xmlns.oracle.com/apps/flex/prc/poz/suppliers/supplierServiceV2/supplierContact/”> <soapenv:Header/> <soapenv:Body> <typ:createSupplier> <typ:supplierRow> <sup:Supplier>SV supplier01 Corporation</sup:Supplier> <sup:BusinessRelationship>SPEND_AUTHORIZED</sup:BusinessRelationship> <sup:TaxOrganizationType>CORPORATION</sup:TaxOrganizationType> <sup:SupplierType>SUPPLIER</sup:SupplierType> <sup:AlternateName>SV supplier 01</sup:AlternateName> <sup:SupplierBusinessClassifications> <sup:Operation>CREATE</sup:Operation> <sup:BusinessClassification>WOMAN_OWNED</sup:BusinessClassification> <sup:CertifyingAgency>Association for Women Owned Business</sup:CertifyingAgency> <sup:CertificateNumber>AS105</sup:CertificateNumber>…
Read MoreSample Payload to update AP Invoice Header level DFF attribute: Payload: <soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:typ=”http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/” xmlns:erp=”http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/”> <soapenv:Header/> <soapenv:Body> <typ:updateDffEntityDetails> <typ:operationMode>single</typ:operationMode> <typ:object> <erp:EntityName>Payables Invoice</erp:EntityName> <erp:ContextValue>JLxMXPayablesInformation</erp:ContextValue> <erp:UserKeyA>DFF-1</erp:UserKeyA> <erp:UserKeyB>Vision Operations sample</erp:UserKeyB> <erp:UserKeyC>XXHealth Care</erp:UserKeyC> <erp:UserKeyD>12136</erp:UserKeyD>…
Read MoreCREATE OR REPLACE PROCEDURE INSERT_SINGLE_BANKS IS x_response_rec apps.iby_fndcpt_common_pub.result_rec_type; l_init_msg_list VARCHAR2 (2000); o_bank_id NUMBER; x_return_status VARCHAR2 (3000); l_msg_count NUMBER; l_msg_data VARCHAR2 (3000); l_msg_dummy VARCHAR2 (3000); l_output VARCHAR2 (3000); l_extbank_rec apps.iby_ext_bankacct_pub.extbank_rec_type; l_ext_bank_branch_rec…
Read MoreVarious Date Converter, Formatter and Validations Reusable Methods in OAF /**=============================================== * Methods related to Date Operation Starts Here * =================================================*/ /** * Method that returns the current system date.…
Read More