ENGINATICS
SYSTEM_ADMINISTRATOR
SYSADMIN
C6E085D46FCF51A9E05362FB09050512Y
select
distinct lad.bol_no,
hdr.orgn_code,
cust.cust_name,
RPAD(sy.addr1,40)||
RPAD(sy.addr2,40)||
RPAD(sy.addr3,40)||
RPAD(sy.addr4,40),
sy.state_code,
sy.postal_code,
lad.bolship_wt,
ship.shipper_name,
lad.bol_um,
dtl.ship_mthd
from
op_bill_lad lad,
op_ordr_hdr hdr,
op_ordr_dtl dtl,
op_cust_mst cust,
op_ship_mst ship,
sy_addr_mst sy,
ic_item_mst item,
op_hold_cds hold
where
lad.shipper_code = ship.shipper_code
and lad.bol_id = dtl.bol_id
and dtl.bol_id !=0
and hdr.shipcust_id = cust.cust_id
and dtl.shipaddr_id = sy.addr_id
and hdr.order_id = dtl.order_id
and item.item_id = dtl.item_id
and hold.holdreas_code = dtl.holdreas_code
and hold.shipping_ind != 1
and lad.orgn_code=:p_default_orgn
&PARAM_WHERE_CLAUSE
GROUP BY
lad.bol_no,
hdr.orgn_code,
cust.cust_name,
sy.addr1,
sy.addr2,
sy.addr3,
sy.addr4,
sy.state_code,
sy.postal_code,
lad.bolship_wt,
lad.bol_um,
ship.shipper_name,
dtl.ship_mthd
ORDER BY
LAD.BOL_NO &P_SORT
GML
RIBOL_XML
AR
GML تقرير بوليصة الشحن
Imported from BI Publisher
Description: تقرير بوليصة شحن عملية OPM
Application: الإجراءات التنظيمية للتصنيع التشغيلي
Source: تقرير بوليصة الشحن (XML)
Short Name: RIBOL_XML
DB package: GML_RIBOL_XMLP_PKG
D
GML Frachtbrief
Imported from BI Publisher
Description: Auswertung "Frachtbriefe" in OPM OP
Application: Process Manufacturing Logistik
Source: Frachtbrief (XML)
Short Name: RIBOL_XML
DB package: GML_RIBOL_XMLP_PKG
E
GML Conocimiento de Embarque
Imported from BI Publisher
Description: Informe Conocimiento de Embarque de OPM OP
Application: Process Manufacturing Logistics
Source: Conocimiento de Embarque (XML)
Short Name: RIBOL_XML
DB package: GML_RIBOL_XMLP_PKG
F
GML Bordereau de chargement
Imported from BI Publisher
Description: Etat Bordereau de chargement d'OPM OP
Application: Process Manufacturing Logistics
Source: Bordereau de chargement (XML)
Short Name: RIBOL_XML
DB package: GML_RIBOL_XMLP_PKG
I
GML Rapporto Polizza di carico
Imported from BI Publisher
Description: Rapporto Polizze di carico di OPM OP
Application: Process Manufacturing Logistics
Source: Rapporto Polizza di carico (XML)
Short Name: RIBOL_XML
DB package: GML_RIBOL_XMLP_PKG
JA
GML 貨物引換証レポート
Imported from BI Publisher
Description: OPM OPの貨物引換証レポート
Application: Process Manufacturing Logistics
Source: 貨物引換証レポート(XML)
Short Name: RIBOL_XML
DB package: GML_RIBOL_XMLP_PKG
KO
GML 선하증권 보고서
Imported from BI Publisher
Description: OPM OP의 선하증권 보고서
Application: Process Manufacturing Logistics
Source: 선하증권 보고서(XML)
Short Name: RIBOL_XML
DB package: GML_RIBOL_XMLP_PKG
PTB
GML Relatório de Conhecimento de Embarque
Imported from BI Publisher
Description: Relatório de Conhecimentos de Embarque da OC do OPM
Application: Process Manufacturing Logistics
Source: Relatório de Conhecimento de Embarque (XML)
Short Name: RIBOL_XML
DB package: GML_RIBOL_XMLP_PKG
RU
GML Отчет о коносаменте
Imported from BI Publisher
Description: Коносаменты в ЗП УНП
Application: Логистика УНП
Source: Отчет о коносаменте (XML)
Short Name: RIBOL_XML
DB package: GML_RIBOL_XMLP_PKG
S
GML Konossement - rapport
Imported from BI Publisher
Description: Konossement - rapport i OPM OB
Application: Process Manufacturing Logistics
Source: Konossement - rapport (XML)
Short Name: RIBOL_XML
DB package: GML_RIBOL_XMLP_PKG
TR
GML Konşimento Raporu
Imported from BI Publisher
Description: OPM OP Konşimento Raporu
Application: Üretim Prosesi Lojistik
Source: Konşimento Raporu (XML)
Short Name: RIBOL_XML
DB package: GML_RIBOL_XMLP_PKG
US
GML Bill Of Lading
Imported from BI Publisher
Description: Bills Of Lading Report of OPM OP
Application: Process Manufacturing Logistics
Source: Bill Of Lading Report (XML)
Short Name: RIBOL_XML
DB package: GML_RIBOL_XMLP_PKG
ZHS
GML 提单报表
Imported from BI Publisher
Description: OPM OP 的提单报表
Application: OPM 采购管理系统
Source: 提单报表 (XML)
Short Name: RIBOL_XML
DB package: GML_RIBOL_XMLP_PKG
BI Publisher
&p_sort
¶m_where_clause
:cp_orgn_name
:cp_sort_1
:cp_user
:p_conc_request_id
:p_default_orgn
:p_default_user
:p_from_shipment_no
:p_sort
:p_sort_asc_desc
:p_to_shipment_no
:param_where_clause
:prn_lines
1
-30
:p_default_orgn
Char
fnd_profile.value('GEMMS_DEFAULT_ORGN')
Y
AR
التنظيم
التنظيم
D
Organisation
Organisation
E
Organización
Organización
F
org.
org.
I
Organizzazione
Organizzazione
JA
組織
組織
KO
조직
조직
PTB
org.
org.
RU
орг.
орг.
S
org.
org.
TR
organizasyon
organizasyon
US
orgn
orgn
ZHS
组织
组织
2
-20
:p_default_user
Number
fnd_profile.value('USER_ID')
Y
AR
مستخدم
مستخدم
D
Benutzer
Benutzer
E
usuario
usuario
F
Utilisateur
Utilisateur
I
utente
utente
JA
ユーザー
ユーザー
KO
사용자
사용자
PTB
usuário
usuário
RU
пользователь
пользователь
S
användare
användare
TR
kullanıcı
kullanıcı
US
user
user
ZHS
用户
用户
3
10
:p_from_shipment_no
LOV Oracle
OP_SHIPMENT_NO
Y
select
bol_no id,
bol_no value,
null description
from
op_bill_lad
where delete_mark=0
and orgn_code=
fnd_profile.value('GEMMS_DEFAULT_ORGN')
order by
bol_no
AR
من رقم الشحنة
من رقم الشحنة
D
Von Anlieferungs-Nr
Von Anlieferungs-Nr
E
De Número de Envío
De Número de Envío
F
Num. livraison - De
Num. livraison - De
I
N. spedizione - Da
N. spedizione - Da
JA
出荷番号:自
出荷番号:自
KO
출하 번호: 부터
출하 번호: 부터
PTB
Número da Entrega - De
Número da Entrega - De
RU
Номер поставки с
Номер поставки с
S
Från leveransnr
Från leveransnr
TR
İlk Sevkiyat No
İlk Sevkiyat No
US
From Shipment No
From Shipment No
ZHS
起始发运编号
起始发运编号
4
20
:p_to_shipment_no
LOV Oracle
OP_SHIPMENT_NO
Y
select
bol_no id,
bol_no value,
null description
from
op_bill_lad
where delete_mark=0
and orgn_code=
fnd_profile.value('GEMMS_DEFAULT_ORGN')
order by
bol_no
:$flex$.from_shipment_no
AR
إلى رقم الشحنة
إلى رقم الشحنة
D
Bis Anlieferungs-Nr
Bis Anlieferungs-Nr
E
A Número de Envío
A Número de Envío
F
Num. livraison - A
Num. livraison - A
I
N. spedizione - A
N. spedizione - A
JA
出荷番号:至
出荷番号:至
KO
출하 번호: 까지
출하 번호: 까지
PTB
Número da Entrega - Até
Número da Entrega - Até
RU
Номер поставки по
Номер поставки по
S
Till leveransnr
Till leveransnr
TR
Son Sevkiyat No
Son Sevkiyat No
US
To Shipment No
To Shipment No
ZHS
终止发运编号
终止发运编号
5
30
:p_sort_asc_desc
LOV Oracle
GEMMS_OP_RIBOL_SO
Y
select
lookup_code id,
lookup_code value,
meaning description
from
gem_lookups
where lookup_type='GEMMS_OP_RIBOL'
order by lookup_code
Y
AR
ترتيب الفرز
ترتيب الفرز
D
Sortierfolge
Reihenfolge
E
Orden de Clasificación
Orden de Clasificación
F
Ordre de tri
Ordre de tri
I
Ordinamento
Ordinamento
JA
ソート順
ソート順
KO
정렬 순서
정렬 순서
PTB
Ordem de Classificação
Ordem de Classificação
RU
Порядок сортировки
Порядок сортировки
S
Sorteringsordning
Sorteringsordning
TR
Sıralama Sırası
Sıralama Sırası
US
Sort Order
Sort Order
ZHS
排序顺序
排序顺序