DBA Data[Home] [Help]

APPS.CTO_MSUTIL_PUB dependencies on OE_SYS_PARAMETERS

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

4671:
4672: select distinct ou_id
4673: BULK COLLECT INTO xOrgLst
4674: from
4675: ( select distinct to_number(nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',ood.operating_unit),-99)) ou_id
4676: from inv_organization_info_v ood,
4677: bom_cto_src_orgs bcso
4678: where ( ood.organization_id = bcso.organization_id
4679: or

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

4695: and bcso.line_id = pModelLineId
4696: )
4697: UNION /* added for bug 4291847. item should be enabled in validation org of operating unit where the order was entered */
4698: ( select
4699: to_number(nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',oel.org_id),-99)) ou_id
4700: from oe_order_lines_all oel where oel.line_id = pModelLineid )
4701: );
4702:
4703: