ENGINATICS
SYSTEM_ADMINISTRATOR
SYSADMIN
C6E085D46F3B51A9E05362FB09050512Y
SELECT
ps.invoice_currency_code Currency_Main,
nvl(status.meaning,'') Account_Status,
decode (upper(:p_order_by),'CUSTOMER', substrb(party.party_name,1,50), NULL) Dummy_Cust,
decode (upper(:p_order_by),'CUSTOMER NUMBER',cust.account_number,NULL) Dummy_Cust_no,
collect.name Dummy_Collect,
substrb(party.party_name,1,50) Customer_Name,
cust.account_number Customer_Number,
cust.cust_account_id Customer_Id,
trunc(sysdate - decode(hist.creation_date,NULL,max(cust.creation_date),hist.creation_date)) Days_On_Credit_Hold,
sum(round(ps.amount_due_remaining, 2)) Balance_Due,
sum(decode(sign(trunc(sysdate) - ps.due_date),
1, round(ps.amount_due_remaining, 2),
0)) Balance_Past_Due ,
acct_site.cust_acct_site_id Address_Id,
loc.address1 Address1,
loc.address2 Address2,
loc.address3 Address3,
loc.address4 Address4,
substrb(loc.city,1,22-nvl(lengthb(loc.state || loc.postal_code),0))
|| ', ' || loc.state || ' ' || loc.postal_code City_State_Zip,
yesno.meaning,
decode(upper(:p_order_by),
'CUSTOMER', substrb(party.party_name,1,50),
'CUSTOMER NUMBER',cust.account_number,
'COLLECTOR', collect.name,
substrb(party.party_name,1,50)) order_by,
AR_ARXCHR_XMLP_PKG.c_no_data_foundformula(ps.invoice_currency_code) C_NO_DATA_FOUND,
--&Currency_Main c_currency_label,
ps.invoice_currency_code c_currency_label,
--&account_status c_status_label,
nvl(status.meaning,'') c_status_label,
AR_ARXCHR_XMLP_PKG.c_get_phone_numberformula(acct_site.cust_acct_site_id, cust.cust_account_id) C_GET_PHONE_NUMBER,
AR_ARXCHR_XMLP_PKG.c_primary_contactformula(acct_site.cust_acct_site_id) C_PRIMARY_CONTACT,
AR_ARXCHR_XMLP_PKG.c_phone_number_p c_phone_number,
AR_ARXCHR_XMLP_PKG.c_contact_id_p c_contact_id,
AR_ARXCHR_XMLP_PKG.c_contact_name_p c_contact_name
FROM
hz_cust_accounts cust,
hz_parties party,
hz_customer_profiles profile,
ar_credit_histories hist,
ar_collectors collect,
ar_payment_schedules_all ps,
hz_cust_site_uses_all site,
hz_cust_acct_sites_all acct_site,
hz_party_sites party_site,
hz_locations loc,
ar_lookups status,
ar_lookups yesno
WHERE
profile.cust_account_id = cust.cust_account_id
and cust.party_id = party.party_id
and profile.site_use_id is null
and profile.credit_hold = 'Y'
and hist.customer_id(+) = cust.cust_account_id
and hist.on_hold(+) = 'N'
and hist.site_use_id(+) is null
and not exists
(select 'newer on_hold record exists'
from ar_credit_histories hist2
where hist2.customer_id = hist.customer_id
and hist2.site_use_id is null
and hist2.on_hold = 'N'
and (hist2.creation_date > hist.creation_date
or
(hist2.creation_date = hist.creation_date
and hist2.credit_history_id > hist.credit_history_id)))
and collect.collector_id = profile.collector_id
and profile.account_status = status.lookup_code(+)
and status.lookup_type(+) = 'ACCOUNT_STATUS'
and acct_site.cust_account_id = cust.cust_account_id
and acct_site.party_site_id = party_site.party_site_id
and loc.location_id = party_site.location_id
and acct_site.cust_acct_site_id = site.cust_acct_site_id
and site.site_use_code = 'BILL_TO'
and ps.customer_site_use_id(+) = site.site_use_id
and ps.status(+) = 'OP'
and site.primary_flag = yesno.lookup_code
and yesno.lookup_type = 'YES/NO'
&lp_status_low
&lp_status_high
&lp_customer_name_low
&lp_customer_name_high
&lp_customer_number_low
&lp_customer_number_high
&lp_collector_low
&lp_collector_high
&lp_currency_code
&p_org_where_addr
GROUP BY
ps.invoice_currency_code,
status.meaning,
party.party_name,
cust.account_number,
cust.cust_account_id,
hist.creation_date,
ps.customer_site_use_id,
acct_site.cust_acct_site_id,
loc.address1,
loc.address2,
loc.address3,
loc.address4,
loc.city,
loc.state,
loc.postal_code,
yesno.meaning,
collect.name
UNION
SELECT
ps.invoice_currency_code,
nvl(status.meaning,''),
decode (upper(:p_order_by),'CUSTOMER',substrb(party.party_name,1,50), NULL) Dummy_Cust,
decode (upper(:p_order_by),'CUSTOMER NUMBER',cust.account_number,NULL) Dummy_Cust_no,
collect.name Dummy_Collect,
substrb(party.party_name,1,50) customer_name,
cust.account_number customer_number,
cust.cust_account_id customer_id,
trunc(sysdate - decode(hist.creation_date,NULL,max(cust.creation_date),hist.creation_date)),
sum(round(ps.amount_due_remaining, 2)),
sum(decode(sign(trunc(sysdate) - ps.due_date),
1, round(ps.amount_due_remaining, 2),
0)),
acct_site.cust_acct_site_id address_id,
loc.address1,
loc.address2,
loc.address3,
loc.address4,
substrb(loc.city,1,22-nvl(lengthb(loc.state || loc.postal_code),0))
|| ', ' || loc.state || ' ' || loc.postal_code,
yesno.meaning,
decode(upper(:p_order_by),
'CUSTOMER', substrb(party.party_name,1,50),
'CUSTOMER NUMBER',cust.account_number,
'COLLECTOR', collect.name,
substrb(party.party_name,1,50)),
AR_ARXCHR_XMLP_PKG.c_no_data_foundformula(ps.invoice_currency_code) C_NO_DATA_FOUND,
--&Currency_Main c_currency_label,
ps.invoice_currency_code c_currency_label,
--&account_status c_status_label,
nvl(status.meaning,'') c_currency_label,
AR_ARXCHR_XMLP_PKG.c_get_phone_numberformula(acct_site.cust_acct_site_id, cust.cust_account_id) C_GET_PHONE_NUMBER,
AR_ARXCHR_XMLP_PKG.c_primary_contactformula(acct_site.cust_acct_site_id) C_PRIMARY_CONTACT,
AR_ARXCHR_XMLP_PKG.c_phone_number_p c_phone_number,
AR_ARXCHR_XMLP_PKG.c_contact_id_p c_contact_id,
AR_ARXCHR_XMLP_PKG.c_contact_name_p c_contact_name
FROM
hz_cust_accounts cust,
hz_parties party,
hz_customer_profiles profile,
ar_credit_histories hist,
ar_collectors collect,
ar_payment_schedules_all ps,
hz_cust_site_uses_all site,
hz_cust_acct_sites_all acct_site,
hz_party_sites party_site,
hz_locations loc,
ar_lookups status,
ar_lookups yesno
WHERE
profile.cust_account_id = cust.cust_account_id
and cust.party_id = party.party_id
and profile.site_use_id is not null
and profile.credit_hold = 'Y'
and not exists
(select 'customer level hold exists'
from hz_customer_profiles p
where p.cust_account_id = cust.cust_account_id
and p.site_use_id is null
and p.credit_hold = 'Y')
and hist.customer_id(+) = profile.cust_account_id
and hist.on_hold(+) = 'N'
and hist.site_use_id(+) = profile.site_use_id
and not exists
(select 'newer on_hold record exists'
from ar_credit_histories hist2
where hist2.customer_id = hist.customer_id
and hist2.site_use_id = hist.site_use_id
and hist2.on_hold = 'N'
and (hist2.creation_date > hist.creation_date
or
(hist2.creation_date = hist.creation_date
and hist2.credit_history_id > hist.credit_history_id)))
and collect.collector_id = profile.collector_id
and profile.account_status = status.lookup_code(+)
and status.lookup_type(+) = 'ACCOUNT_STATUS'
and site.site_use_id = profile.site_use_id
and site.site_use_code = 'BILL_TO'
and acct_site.cust_acct_site_id = site.cust_acct_site_id
and acct_site.party_site_id = party_site.party_site_id
and loc.location_id = party_site.location_id
and ps.customer_site_use_id(+) = site.site_use_id
and ps.status(+) = 'OP'
and site.primary_flag = yesno.lookup_code
and yesno.lookup_type = 'YES/NO'
&lp_status_low
&lp_status_high
&lp_customer_name_low
&lp_customer_name_high
&lp_customer_number_low
&lp_customer_number_high
&lp_collector_low
&lp_collector_high
&lp_currency_code
&p_org_where_site
GROUP BY
ps.invoice_currency_code,
status.meaning,
party.party_name,
cust.account_number,
cust.cust_account_id,
hist.creation_date,
ps.customer_site_use_id,
acct_site.cust_acct_site_id,
loc.address1,
loc.address2,
loc.address3,
loc.address4,
loc.city,
loc.state,
loc.postal_code,
yesno.meaning,
collect.name
UNION
SELECT
ps.invoice_currency_code,
nvl(status.meaning,''),
decode (upper(:p_order_by),'CUSTOMER', substrb(party.party_name,1,50), NULL) Dummy_Cust,
decode (upper(:p_order_by),'CUSTOMER NUMBER',cust.account_number,NULL) Dummy_Cust_no,
collect.name Dummy_Collect,
substrb(party.party_name,1,50) customer_name,
cust.account_number customer_number,
cust.cust_account_id customer_id,
0,
sum(round(nvl(ps.amount_due_remaining,0), 2)),
sum(decode(sign(trunc(sysdate) - ps.due_date),
1, round(nvl(ps.amount_due_remaining,0), 2),
0)),
to_number(null),
null,
null,
null,
null,
null,
null,
decode(upper(:p_order_by),
'CUSTOMER',substrb(party.party_name,1,50),
'CUSTOMER NUMBER',cust.account_number,
'COLLECTOR', collect.name,
substrb(party.party_name,1,50)),
AR_ARXCHR_XMLP_PKG.c_no_data_foundformula(ps.invoice_currency_code) C_NO_DATA_FOUND,
--&Currency_Main c_currency_label,
ps.invoice_currency_code c_currency_label,
--&account_status c_status_label,
nvl(status.meaning,'') c_status_label,
AR_ARXCHR_XMLP_PKG.c_get_phone_numberformula(to_number(null), cust.cust_account_id) C_GET_PHONE_NUMBER,
AR_ARXCHR_XMLP_PKG.c_primary_contactformula(to_number(null)) C_PRIMARY_CONTACT,
AR_ARXCHR_XMLP_PKG.c_phone_number_p c_phone_number,
AR_ARXCHR_XMLP_PKG.c_contact_id_p c_contact_id,
AR_ARXCHR_XMLP_PKG.c_contact_name_p c_contact_name
FROM
hz_cust_accounts cust,
hz_parties party,
hz_customer_profiles profile,
hz_cust_acct_sites_all acct_site,
ar_collectors collect,
ar_lookups status,
ar_payment_schedules_all ps
WHERE
profile.cust_account_id = cust.cust_account_id
and cust.party_id = party.party_id
and acct_site.cust_account_id = cust.cust_account_id and profile.site_use_id is null
and profile.credit_hold = 'Y'
and collect.collector_id = profile.collector_id
and ps.customer_id (+) = cust.cust_account_id
and ps.customer_site_use_id is null
and ps.status (+) = 'OP'
and profile.account_status = status.lookup_code(+)
and status.lookup_type(+) = 'ACCOUNT_STATUS'
and NVL(ps.ORG_ID, :p_reporting_entity_id) =
DECODE(:p_reporting_level,3000,acct_site.ORG_ID,:p_reporting_entity_id )
&lp_status_low
&lp_status_high
&lp_customer_name_low
&lp_customer_name_high
&lp_customer_number_low
&lp_customer_number_high
&lp_collector_low
&lp_collector_high
&lp_currency_code
&p_org_where_addr
GROUP BY
ps.invoice_currency_code,
status.meaning,
party.party_name,
cust.account_number,
cust.cust_account_id,
collect.name
ORDER BY
1,
2,
19,
10
AR
ARXCHR_XML
AR
AR تقرير إيقاف الائتمان (بتنسيق XML)
Imported from BI Publisher
Description: تقرير إيقاف الائتمان
Application: المقبوضات
Source: تقرير إيقاف الائتمان (بتنسيق XML)
Short Name: ARXCHR_XML
DB package: AR_ARXCHR_XMLP_PKG
D
AR Kreditsperre
Imported from BI Publisher
Description: Auswertung "Kreditsperre"
Application: Debitoren
Source: Kreditsperre (XML)
Short Name: ARXCHR_XML
DB package: AR_ARXCHR_XMLP_PKG
E
AR Créditos Retenidos
Imported from BI Publisher
Description: Informe de créditos retenidos
Application: Receivables
Source: Créditos Retenidos (XML)
Short Name: ARXCHR_XML
DB package: AR_ARXCHR_XMLP_PKG
F
AR Etat Crédits bloqués
Imported from BI Publisher
Description: Etat des crédits bloqués
Application: Receivables
Source: Etat Crédits bloqués (XML)
Short Name: ARXCHR_XML
DB package: AR_ARXCHR_XMLP_PKG
I
AR Rapporto Blocco credito
Imported from BI Publisher
Description: Rapporto Blocco credito
Application: Receivables
Source: Rapporto Blocco credito (XML)
Short Name: ARXCHR_XML
DB package: AR_ARXCHR_XMLP_PKG
JA
AR 与信保留レポート
Imported from BI Publisher
Description: 与信保留レポート
Application: Receivables
Source: 与信保留レポート(XML)
Short Name: ARXCHR_XML
DB package: AR_ARXCHR_XMLP_PKG
KO
AR 신용 보류 보고서
Imported from BI Publisher
Description: 신용 보류 보고서
Application: Receivables
Source: 신용 보류 보고서(XML)
Short Name: ARXCHR_XML
DB package: AR_ARXCHR_XMLP_PKG
PTB
AR Relatório de Retenção de Crédito
Imported from BI Publisher
Description: Relatório de Retenção de Crédito
Application: Receivables
Source: Relatório de Retenção de Crédito (XML)
Short Name: ARXCHR_XML
DB package: AR_ARXCHR_XMLP_PKG
RU
AR Отчет о блокировках кредита
Imported from BI Publisher
Description: Отчет о блокировках кредита
Application: Дебиторы
Source: Отчет о блокировках кредита (XML)
Short Name: ARXCHR_XML
DB package: AR_ARXCHR_XMLP_PKG
S
AR Kreditspärr - rapport
Imported from BI Publisher
Description: Kreditspärr - rapport
Application: Receivables
Source: Kreditspärr - rapport (XML)
Short Name: ARXCHR_XML
DB package: AR_ARXCHR_XMLP_PKG
TR
AR Kredi Durdurma Raporu
Imported from BI Publisher
Description: Kredi Durdurma Raporu
Application: Alacaklar Muhasebesi
Source: Kredi Durdurma Raporu (XML)
Short Name: ARXCHR_XML
DB package: AR_ARXCHR_XMLP_PKG
US
AR Credit Hold
Imported from BI Publisher
Description: Credit Hold Report
Application: Receivables
Source: Credit Hold Report (XML)
Short Name: ARXCHR_XML
DB package: AR_ARXCHR_XMLP_PKG
ZHS
AR 信用暂挂报表
Imported from BI Publisher
Description: 信用暂挂报表
Application: 应收帐款
Source: 信用暂挂报表 (XML)
Short Name: ARXCHR_XML
DB package: AR_ARXCHR_XMLP_PKG
BI Publisher
&account_status
¤cy_main
&lp_collector_high
&lp_collector_low
&lp_currency_code
&lp_customer_name_high
&lp_customer_name_low
&lp_customer_number_high
&lp_customer_number_low
&lp_status_high
&lp_status_low
&p_org_where_addr
&p_org_where_site
:c_contact_id
:c_contact_name
:c_phone_number
:lp_collector_high
:lp_collector_low
:lp_currency_code
:lp_customer_name_high
:lp_customer_name_low
:lp_customer_number_high
:lp_customer_number_low
:lp_status_high
:lp_status_low
:p_collector_high
:p_collector_low
:p_conc_request_id
:p_currency_code
:p_customer_name_high
:p_customer_name_low
:p_customer_number_high
:p_customer_number_low
:p_order_by
:p_org_where_addr
:p_org_where_ps
:p_org_where_site
:p_reporting_entity_id
:p_reporting_entity_name
:p_reporting_level
:p_reporting_level_name
:p_set_of_books_id
:p_status_high
:p_status_low
:rp_company_name
:rp_data_found
:rp_date_range
:rp_message
:rp_report_name
1
-20
:p_set_of_books_id
LOV Oracle
AR_SRS_SET_OF_BOOKS_ID
Y
select
set_of_books_id id,
set_of_books_id value,
null description
from
ar_system_parameters
order by value,description
select set_of_books_id from ar_system_parameters
Y
AR
دفتر الأستاذ
دفتر الأستاذ
D
Buch
Buch
E
Libro Mayor
Libro mayor
F
Livre
Livre
I
Libro contabile
Libro contabile
JA
元帳
元帳
KO
원장
원장
PTB
Razão
Razão
RU
Книга
Книга
S
Huvudbok
Huvudbok
TR
Defter
Defter
US
Ledger
Ledger
ZHS
分类帐
分类帐
2
10
:p_reporting_level
LOV Oracle
FND_MO_REPORTING_LEVEL
Y
select
lookup_code id,
meaning value,
null description
from
fnd_lookups
where lookup_type='FND_MO_REPORTING_LEVEL'
and lookup_code in (1000,3000)
order by value,description
SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'FND_MO_REPORTING_LEVEL' AND rownum=1
Y
AR
مستوى إعداد التقرير
للإشارة إلى مستوى إعداد التقرير
D
Auswertungsebene
Gibt die Auswertungsebene an
E
Nivel de Informe
Indica el nivel de informe
F
Niveau de reporting
Indique le niveau de reporting
I
Livello di creazione rapporti
Indica il livello di creazione rapporti
JA
レポート・レベル
レポート・レベルの表示
KO
보고 레벨
보고 레벨 표시
PTB
Nível do relatório
Indica o Nível de Geração de Relatórios
RU
Уровень отчетности
Уровень отчетности
S
Rapportnivå
Visar rapportnivå
TR
Raporlama düzeyi
Raporlama Düzeyini Gösterir
US
Reporting level
Indicates Reporting Level
ZHS
报告层
表示报告层
3
20
:p_reporting_entity_id
LOV Oracle
FND_MO_REPORTING_ENTITY
Y
select
entity_id id,
entity_name value,
null description
from
fnd_mo_reporting_entities_v
where reporting_level=:$flex$.fnd_mo_reporting_level
order by value,description
SELECT entity_name, entity_id FROM FND_MO_REPORTING_ENTITIES_V WHERE reporting_level = :$flex$.reporting_level and rownum=1
Y
AR
سياق إعداد التقرير
للإشارة إلى سياق إعداد التقرير
D
Auswertungskontext
Gibt den Auswertungskontext an
E
Contexto del Informe
Indica el contexto del informe
F
Contexte de reporting
Indique le contexte de reporting
I
Contesto creazione rapporti
Indica il contesto di creazione rapporti
JA
レポート・コンテキスト
レポート・コンテキストの表示
KO
보고 컨텍스트
보고 컨텍스트 표시
PTB
Contexto do Relatório
Indica o Contexto para Geração de Relatórios
RU
Контекст отчетности
Контекст отчетности
S
Rapporteringssammanhang
Visar rapporteringssammanhang
TR
Raporlama İçeriği
Raporlama İçeriğini Gösterir
US
Reporting Context
Indicates Reporting Context
ZHS
报告上下文
表示报告上下文
4
30
:p_order_by
LOV Oracle
AR_ARXCHR_SORT_BY
Y
select
lookup_code id,
meaning value,
null description
from
ar_lookups
where lookup_type='SORT_BY_ARXCHR'
order by value,description
Y
AR
ترتيب حسب
يدل على ترتيب الاستعلام
D
Sortieren nach
Sortieroption für die Abfrage
E
Ordenar por
Indica el orden de consulta
F
Tri par
Indique l'ordre de tri de la recherche
I
Ordina per
Indica l'ordinamento della query
JA
ソート・キー
受注照会の表示
KO
정렬 기준
질의 순서 표시
PTB
Ordenar Por
Indica ordenação de consulta
RU
Сортировка
Упорядочение запроса
S
Ordna per
Anger att fråga beställs
TR
Sıralama Bazı
Sorgulama sırasını gösterir
US
Order By
Indicates ordering of query
ZHS
排序依据
表示查询顺序
5
40
:p_status_low
LOV Oracle
AR_ACCOUNT_STATUS
Y
select
lookup_code id,
lookup_code value,
meaning description
from
ar_lookups
where lookup_type='ACCOUNT_STATUS' order by meaning,lookup_code
AR
موقف الحساب
من مدى موقف الحساب
D
Kontenstatus
Von Kontenstatus
E
Estado de la Cuenta
Rango inferior de estado de la cuenta
F
Statut de compte
Début de la fourchette de statuts de compte
I
Stato conto
Valore minimo per lo stato del conto
JA
勘定ステータス
勘定ステータス:自
KO
계정 상태
계정 상태에 대한 하한 범위
PTB
Status da Conta
Faixa de Status da Conta - Inferior
RU
Статус счета
Статус счета с
S
Kontostatus
Nedre intervallgräns för kontostatus
TR
Hesap Statüsü
Hesap Statüsü Alt Aralığı
US
Account Status
Low Range for Account Status
ZHS
帐户状态
帐户状态的下限
6
50
:p_status_high
LOV Oracle
AR_ACCOUNT_STATUS
Y
select
lookup_code id,
lookup_code value,
meaning description
from
ar_lookups
where lookup_type='ACCOUNT_STATUS' order by meaning,lookup_code
AR
موقف الحساب إلى
إلى مدى موقف الحساب
D
Bis Kontenstatus
Bis Kontenstatus
E
A Estado de la Cuenta
Rango superior de estado de cuenta
F
Statut de compte - A
Fin de la fourchette de statuts de compte
I
Stato conto (max)
Valore massimo per lo stato del conto
JA
勘定ステータス:至
勘定ステータス:至
KO
계정 상태 상한
계정 상태에 대한 상한 범위
PTB
Status da Conta - Superior
Faixa de Status da Conta - Superior
RU
Статус счета по
Статус счета по
S
Till kontostatus
Övre intervallgräns för kontostatus
TR
Hesap Statüsü Üst Değeri
Hesap Statüsü Üst Aralığı
US
Account Status High
High Range for Account Status
ZHS
帐户状态上限
帐户状态的上限
7
60
:p_collector_low
LOV Oracle
AR_COLLECTOR_NAME
Y
select
name id,
name value,
null description
from
ar_collectors
where status!='I'
order by name,collector_id
AR
محصل من
من مدى المحصل
D
Von Debitorenbearbeiter
Von Debitorenbearbeiter
E
De Cobrador
Rango inferior de cobrador
F
Agent de recouvrement - De
Début de la fourchette d'agents de recouvrement
I
Esattore (min)
Valore minimo per l'esattore
JA
回収担当:自
回収担当者:自
KO
수금사원 하한
수금사원에 대한 하한 범위
PTB
Cobrador - Inferior
Faixa de Cobradores - Inferior
RU
Сборщик с
Ответственный с
S
Från inkasserare
Nedre intervallgräns för inkasserare
TR
Tahsildar Alt Değeri
Tahsildar Alt Aralığı
US
Collector Low
Low Range for Collector
ZHS
收帐员下限
收帐员的下限
8
70
:p_collector_high
LOV Oracle
AR_COLLECTOR_NAME
Y
select
name id,
name value,
null description
from
ar_collectors
where status!='I'
order by name,collector_id
AR
محصل إلى
إلى مدى المحصل
D
Bis Debitorenbearbeiter
Bis Debitorenbearbeiter
E
A Cobrador
Rango superior de cobrador
F
Agent de recouvrement - A
Fin de la fourchette d'agents de recouvrement
I
Esattore (max)
Valore massimo per l'esattore
JA
回収担当:至
回収担当者:至
KO
수금사원 상한
수금사원에 대한 상한 범위
PTB
Cobrador - Superior
Faixa de Cobradores - Superior
RU
Сборщик по
Ответственный по
S
Till inkasserare
Övre intervallgräns för inkasserare
TR
Tahsildar Üst Değeri
Tahsildar Üst Aralığı
US
Collector High
High Range for Collector
ZHS
收帐员上限
收帐员的上限
9
80
:p_customer_name_low
LOV Oracle
AR_CUSTOMER_NAME
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
cu.cust_account_id in (select cu2.cust_account_id
from hz_cust_accounts cu2,hz_parties party2
where cu2.party_id=party2.party_id
and party2.party_name=
party.party_name)
order by party.party_name
AR
اسم العميل من
من مدى اسم العميل
D
Von Kundenname
Von Kundenname
E
De Nombre de Cliente
Rango inferior de nombre de cliente
F
Nom de client - De
Début de la fourchette des noms de client
I
Nome cliente (min)
Intervallo minimo per nome cliente
JA
顧客名:自
顧客名:自
KO
고객명 하한
고객명에 대한 하한 범위
PTB
Nome do Cliente - Inferior
Faixa Inferior para Nomes de Cliente
RU
Имя заказчика с
Имя заказчика с
S
Från kundnamn
Nedre intervallgräns för kundnamn
TR
Müşteri Adı Alt Değeri
Müşteri Adı Alt Değeri
US
Customer Name Low
Low Range for Customer Name
ZHS
客户名称下限
客户名称下限
10
90
:p_customer_name_high
LOV Oracle
AR_CUSTOMER_NAME
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
cu.cust_account_id in (select cu2.cust_account_id
from hz_cust_accounts cu2,hz_parties party2
where cu2.party_id=party2.party_id
and party2.party_name=
party.party_name)
order by party.party_name
AR
اسم العميل إلى
إلى مدى اسم العميل
D
Bis Kundenname
Bis Kundenname
E
A Nombre de Cliente
Rango superior de nombre de cliente
F
Nom de client - A
Fin de la fourchette des noms de client
I
Nome cliente (max)
Intervallo massimo per nome cliente
JA
顧客名:至
顧客名:至
KO
고객명 상한
고객명에 대한 상한 범위
PTB
Nome do Cliente - Superior
Faixa Superior para Nomes de Cliente
RU
Имя заказчика по
Имя заказчика по
S
Till kundnamn
Övre intervallsgräns för kundnamn
TR
Müşteri Adı Üst Değeri
Müşteri Adı Üst Değeri
US
Customer Name High
High Range for Customer Name
ZHS
客户名称上限
客户名称的上限
11
100
:p_customer_number_low
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
Von Kundennummer
E
De Número de Cliente
Rango inferior de número de cliente
F
Numéro de client - De
Début de la fourchette des numéros de client
I
Numero cliente (min)
Valore minimo per il numero del cliente
JA
顧客番号:自
顧客番号:自
KO
고객 번호 하한
고객 번호에 대한 하한 범위
PTB
Número do Cliente - Inferior
Faixa Inferior para Números do Cliente
RU
Номер заказчика с
Номер заказчика с
S
Från kundnummer
Nedre intervallgräns för kundnummer
TR
Müşteri Numarası Alt Değeri
Müşteri Numarası için Alt Aralık
US
Customer Number Low
Low Range for Customer Number
ZHS
客户编号下限
客户编号下限
12
110
:p_customer_number_high
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
Bis Kundennummer
E
A Número de Cliente
Rango superior de número de cliente
F
Numéro de client - A
Fin de la fourchette des numéros de client
I
Numero cliente (max)
Valore massimo per il numero del cliente
JA
顧客番号:至
顧客番号:至
KO
고객 번호 상한
고객 번호에 대한 상한 범위
PTB
Número do Cliente - Superior
Faixa Superior para Números do Cliente
RU
Номер заказчика по
Номер заказчика по
S
Till kundnummer
Övre intervallsgräns för kundnummer
TR
Müşteri Numarası Üst Değeri
Müşteri Numarası için Üst Aralık
US
Customer Number High
High Range for Customer Number
ZHS
客户编号上限
客户编号的上限
13
120
:p_currency_code
LOV Oracle
AR_SRS_CURRENCY
Y
select
currency_code id,
currency_code value,
name description
from
fnd_currencies_vl
where currency_flag='Y'
and enabled_flag in ('Y','N')
order by currency_code
AR
العملة
رمز العملة
D
Währung
Währung
E
Divisa
Código de divisa
F
Devise
Code devise
I
Divisa
Codice della divisa
JA
通貨
通貨コード
KO
통화
통화 코드
PTB
Moeda
Código da Moeda
RU
Валюта
Код валюты
S
Valuta
Valutakod
TR
Para Birimi
Para Birimi Kodu
US
Currency
Currency Code
ZHS
币种
币种代码