SELECT DISTINCT rcta.trx_number invoice_number, –gd.gl_date, hp.party_name customer_name, rctla.line_number, rctla.description, rctla.uom_code, rctla.quantity_invoiced qty, rctla.unit_selling_price unit_price, rctla.revenue_amount amount, ( SELECT jtl.tax_rate_percentage FROM apps.jai_tax_lines jtl WHERE rcta.trx_number = jtl.trx_number AND rctla.line_number = jtl.trx_line_number…
Read MoreSELECT gjst.user_je_source_name source, ( SELECT gjct.user_je_category_name FROM apps.gl_je_categories_tl gjct WHERE gjh.je_category = gjct.je_category_name AND language = ‘US’ ) category, gjh.name batch_name, gjh.description header_description, gjl.je_line_num, gjl.description line_description, CASE WHEN gjl.entered_dr IS…
Read MoreSELECT hou.name operating_unit, xep.name legal_entity, cebb.bank_name, cebb.bank_number, cebb.bank_branch_name, cebb.bank_branch_number, cebb.bank_branch_type, — Branch type indicates which list the bank routing number is on. Valid types are ABA, CHIPS, SWIFT, OTHER. cbv.address_line1,…
Read MoreASMLIB is a storage management interface. ASMLIB is not required for ASM to function; it is like an add-on library that simplifies the tasks of managing and discovering the disks.…
Read MoreThe auditing mechanism for Oracle is extremely flexible. Oracle stores information that is relevant to auditing in its data dictionary. Every time when a user attempts anything in the database…
Read MoreCloud 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 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 MoreThe “Accounts Payable Trial Balance” / “Open Account Balances Data Manager” report having severe performance issues. The rebuild it self taken more than 4 hours. Also there was too much…
Read MoreAIM: Component is used for Create the Requisition against the Blanket Purchase Agreement For different Locations. SCRIPT: CREATE OR REPLACE PACKAGE BODY APPS.XXTTK_BPO_PKG IS PROCEDURE XXTTK_REQ ( ERRORBUF OUT VARCHAR2…
Read More