DBA Data[Home] [Help]

APPS.CTO_MSUTIL_PUB dependencies on OE_SYS_PARAMETERS

Line 5205: ( select distinct to_number(nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',ood.operating_unit),-99)) ou_id

5201:
5202: select distinct ou_id
5203: BULK COLLECT INTO xOrgLst
5204: from
5205: ( select distinct to_number(nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',ood.operating_unit),-99)) ou_id
5206: from inv_organization_info_v ood,
5207: bom_cto_src_orgs bcso
5208: where ( ood.organization_id = bcso.organization_id
5209: or

Line 5229: to_number(nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',oel.org_id),-99)) ou_id

5225: and bcso.line_id = pModelLineId
5226: )
5227: UNION /* added for bug 4291847. item should be enabled in validation org of operating unit where the order was entered */
5228: ( select
5229: to_number(nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',oel.org_id),-99)) ou_id
5230: from oe_order_lines_all oel where oel.line_id = pModelLineid )
5231: );
5232:
5233: