ENGINATICS
SYSTEM_ADMINISTRATOR
SYSADMIN
A3BBDAFDD5DA874FE053B46B6358F206Y
select * from OE_ECC_ORDER_LINES_V
where 1=1
US
ONT-ECC Command Center
1=1
1
10
1=1
upper(customer) like upper(:customer_name)
LOV
AR Customer Name (Organizations Only)
A7086A92F0E7B16EE053BB6B63589F6B
Y
select
hp.party_name value,
hca.account_number||' ('||initcap(hp.party_type)||')' description
from
hz_parties hp,
hz_cust_accounts hca
where
hp.party_id=hca.party_id and
hp.party_type='ORGANIZATION'
order by
hp.party_name
A. C. Networks
US
Customer Name
2
20
1=1
order_type=:order_type
LOV
ONT Order Type
8E2FF36EDEE879D2E0530100007F1FF2
Y
select
ottt.name value,
xxen_util.meaning(otta.order_category_code,'ORDER_CATEGORY',660) description
from
oe_transaction_types_all otta,
oe_transaction_types_tl ottt
where
(:$flex$.operating_unit is null or otta.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and
otta.transaction_type_code='ORDER' and
otta.transaction_type_id=ottt.transaction_type_id and
ottt.language=userenv('lang')
order by
decode(otta.order_category_code,'ORDER',1,'MIXED',2,3),
ottt.name
Standard
US
Order Type
3
30
1=1
flow_status_code=xxen_util.lookup_code(:header_status,'FLOW_STATUS',660)
LOV
ONT Order Status
8E2FF36EDF0979D2E0530100007F1FF2
Y
select
flvv.meaning value,
flvv.lookup_code description
from
fnd_lookup_values_vl flvv
where
flvv.lookup_type='FLOW_STATUS' and
flvv.view_application_id=660 and
flvv.security_group_id=0
order by
flvv.meaning
Closed
US
Order Status
4
40
1=1
operating_unit=:operating_unit
LOV
HR Operating Unit
8E2FF36EDEB979D2E0530100007F1FF2
Y
select
hou.name value,
null description
from
hr_operating_units hou
where
sysdate between hou.date_from and nvl(hou.date_to,sysdate) and
(:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and
hou.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='OU')
order by
hou.name
select
haou.name
from
hr_all_organization_units haou
where
haou.organization_id=nvl((select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1),fnd_global.org_id)
US
Operating Unit