ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EECF3869E053B46B63588994Y SELECT NULL null_cbp, RALU10.MEANING PRIMARY_cbp, RALU1.MEANING USAGE_cbp, RALU8.MEANING STATUS_cbp, RASU1.LOCATION LOCATION_cbp, RASU2.LOCATION BILL_TO_LOCATION_cbp, ARCPC.NAME CREDIT_PROFILE_CLASS_cbp, RASU1.SIC_CODE SIC_CODE_cbp, RAT.NAME PAYMENT_TERM_cbp, RALU4.MEANING GSA_INDICATOR_cbp, RALU5.MEANING SHIP_PARTIAL_cbp, RALU6.MEANING SHIP_VIA_cbp, RALU7.MEANING FOB_POINT_cbp, SOOT.NAME ORDER_TYPE_cbp, RASU1.FREIGHT_TERM FREIGHT_TERM_cbp, SOPL.NAME PRICE_LIST_cbp, RASU1.CUST_ACCT_SITE_ID ADDRESS_ID_cbp, DECODE(RASU1.CONTACT_ID, NULL, NULL, SUBSTRB(PARTY.PERSON_LAST_NAME,1,50)||', '|| SUBSTRB(PARTY.PERSON_FIRST_NAME,1,40) ) CONTACT_cbp, RASU1.TAX_REFERENCE TAX_REFERENCE_cbp , RASU1.TAX_CODE TAX_CODE_cbp, ARVT.TAX_RATE TAX_RATE_cbp, SOLU1.MEANING FREIGHT_TERMS_cbp, FCLU.MEANING DEMAND_CLASS_cbp, RASU1.SITE_USE_ID SITE_USE_ID_cbp, null TERRITORY_cbp, ORGD.ORGANIZATION_NAME WAREHOUSE_cbp, ORGF.DESCRIPTION CARRIER_cbp, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_territory', 'AR', 'CT#', 101, NULL, RATT.TERRITORY_ID, 'ALL', 'Y', 'VALUE') D_TERRITORY FROM HZ_CUST_SITE_USES RASU1, HZ_CUST_SITE_USES RASU2, RA_TERMS RAT, SO_ORDER_TYPES SOOT, SO_PRICE_LISTS SOPL, AR_VAT_TAX ARVT, AR_LOOKUPS RALU1, AR_LOOKUPS RALU4, AR_LOOKUPS RALU5, AR_LOOKUPS RALU6, AR_LOOKUPS RALU7, AR_LOOKUPS RALU8, AR_LOOKUPS RALU10, SO_LOOKUPS SOLU1, HZ_CUSTOMER_PROFILES ARCP, HZ_CUST_PROFILE_CLASSES ARCPC, HZ_CUST_ACCOUNT_ROLES RACO, HZ_RELATIONSHIPS REL, HZ_PARTIES PARTY, FND_COMMON_LOOKUPS FCLU, ORG_ORGANIZATION_DEFINITIONS ORGD, ORG_FREIGHT ORGF, RA_TERRITORIES RATT WHERE RALU1.LOOKUP_CODE = RASU1.SITE_USE_CODE AND RALU1.LOOKUP_TYPE = 'SITE_USE_CODE' AND RALU10.LOOKUP_CODE = RASU1.PRIMARY_FLAG AND RALU10.LOOKUP_TYPE = 'YES/NO' AND RALU4.LOOKUP_CODE(+) = RASU1.GSA_INDICATOR AND RALU4.LOOKUP_TYPE(+) = 'YES/NO' AND RALU5.LOOKUP_CODE(+) = RASU1.SHIP_PARTIAL AND RALU5.LOOKUP_TYPE(+) = 'YES/NO' AND RALU6.LOOKUP_CODE(+) = RASU1.SHIP_VIA AND RALU6.LOOKUP_TYPE(+) = 'SHIP_VIA' AND RALU7.LOOKUP_CODE(+) = RASU1.FOB_POINT AND RALU7.LOOKUP_TYPE(+) = 'FOB' AND RALU8.LOOKUP_CODE = RASU1.STATUS AND RALU8.LOOKUP_TYPE = 'CODE_STATUS' AND RASU2.SITE_USE_ID(+) = RASU1.BILL_TO_SITE_USE_ID AND RAT.TERM_ID(+) = RASU1.PAYMENT_TERM_ID AND SOOT.ORDER_TYPE_ID(+) = RASU1.ORDER_TYPE_ID AND SOPL.PRICE_LIST_ID(+) = RASU1.PRICE_LIST_ID AND ARCP.SITE_USE_ID(+) = RASU1.SITE_USE_ID AND ARCPC.PROFILE_CLASS_ID(+) = ARCP.PROFILE_CLASS_ID AND RACO.CUST_ACCOUNT_ROLE_ID (+) = RASU1.CONTACT_ID AND RACO.PARTY_ID = REL.PARTY_ID(+) AND RACO.ROLE_TYPE(+) = 'CONTACT' AND REL.SUBJECT_ID = PARTY.PARTY_ID(+) AND REL.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES' AND REL.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES' AND REL.DIRECTIONAL_FLAG(+) = 'F' AND ARVT.TAX_CODE(+) = RASU1.TAX_CODE AND TRUNC(SYSDATE) BETWEEN NVL(ARVT.START_DATE, TRUNC(SYSDATE)) AND NVL(ARVT.END_DATE, TRUNC(SYSDATE)) AND SOLU1.LOOKUP_CODE(+) = RASU1.FREIGHT_TERM AND SOLU1.LOOKUP_TYPE(+) = 'FREIGHT_TERMS' AND FCLU.LOOKUP_CODE(+) = RASU1.DEMAND_CLASS_CODE AND FCLU.LOOKUP_TYPE(+) = 'DEMAND_CLASS' AND ORGD.ORGANIZATION_ID(+) = RASU1.WAREHOUSE_ID AND ORGF.FREIGHT_CODE(+) = RASU1.SHIP_VIA AND ORGF.ORGANIZATION_ID(+) = :ITEM_FLEX_STRUCTURE AND RATT.TERRITORY_ID(+) = RASU1.TERRITORY_ID and RASU1.CUST_ACCT_SITE_ID=:ADDRESS_ID_ca ORDER BY RALU10.MEANING, RALU1.MEANING, RALU8.MEANING, RASU1.LOCATION AR RAXCUSLR_XML AR AR قائمة العملاء - تفاصيل (بتنسيق XML) Application: المقبوضات Source: قائمة العملاء - تفاصيل (بتنسيق XML) Short Name: RAXCUSLR_XML DB package: AR_RAXCUSLR_XMLP_PKG D AR Kundenliste - Details Application: Debitoren Source: Kundenliste - Details (XML) Short Name: RAXCUSLR_XML DB package: AR_RAXCUSLR_XMLP_PKG F AR Liste détaillée des clients Application: Receivables Source: Liste détaillée des clients (XML) Short Name: RAXCUSLR_XML DB package: AR_RAXCUSLR_XMLP_PKG US AR Customer Listing - Detail Application: Receivables Source: Customer Listing - Detail (XML) Short Name: RAXCUSLR_XML DB package: AR_RAXCUSLR_XMLP_PKG ZHS AR 客户列表 - 明细 Application: 应收帐款 Source: 客户列表 - 明细 (XML) Short Name: RAXCUSLR_XML DB package: AR_RAXCUSLR_XMLP_PKG BI Publisher :address_id_ca :c_industry_code :c_sales_title :c_salesrep_title :c_salester_title :hcn :item_flex_structure :lcn :lp_customer_high :lp_customer_low :lp_hcn :lp_lcn :operating_unit :p_conc_request_id :p_customer_name_high :p_customer_name_low :p_order_by :p_veh_from_table :p_veh_install_status :p_veh_select_column1 :p_veh_select_column2 :p_veh_where_clause1 :p_veh_where_clause2 :rp_company_name :rp_data_found :rp_report_name :terr_flex_all_seg :today 1 10 :p_order_by LOV Oracle AR_RAXCUSLR_SORT_BY Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='SORT_BY_RAXCUSLR' order by meaning Y AR ترتيب حسب D Sortieren nach F Tri par US Order By ZHS 排序依据 2 20 :p_customer_name_low LOV Oracle AR_CUSTOMER_NAME_WIDE Y Y select party.party_name id, party.party_name value, null description from hz_cust_accounts cu,hz_parties party where cu.party_id=party.party_id and exists (select cas.cust_account_id from hz_cust_acct_sites cas where cas.cust_account_id=cu.cust_account_id) order by value,description AR اسم العميل من D Von Kundenname F Nom de client - De US Customer Name Low ZHS 客户名称下限 3 30 :p_customer_name_high LOV Oracle AR_CUSTOMER_NAME_WIDE Y Y select party.party_name id, party.party_name value, null description from hz_cust_accounts cu,hz_parties party where cu.party_id=party.party_id and exists (select cas.cust_account_id from hz_cust_acct_sites cas where cas.cust_account_id=cu.cust_account_id) order by value,description AR اسم العميل إلى D Bis Kundenname F Nom de client - A US Customer Name High ZHS 客户名称上限 4 40 :lcn LOV Oracle AR_CUSTOMER_NUMBER Y Y select cust.account_number id, cust.account_number value, null description from hz_cust_accounts cust,hz_parties party where cust.party_id=party.party_id order by cust.account_number AR رقم العميل من D Von Kundennummer F Numéro de client - De US Customer Number Low ZHS 客户编号下限 5 50 :hcn LOV Oracle AR_CUSTOMER_NUMBER Y Y select cust.account_number id, cust.account_number value, null description from hz_cust_accounts cust,hz_parties party where cust.party_id=party.party_id order by cust.account_number AR رقم العميل إلى D Bis Kundennummer F Numéro de client - A US Customer Number High ZHS 客户编号上限