DBA Data[Home] [Help]

APPS.CTO_ATP_INTERFACE_PK dependencies on OE_SYSTEM_PARAMETERS_ALL

Line 2563: oe_system_parameters_all ospa

2559: BEGIN
2560: select nvl(master_organization_id,-99) --bugfix 2646849: master_organization_id can be 0
2561: into l_validation_org
2562: from oe_order_lines_all oel,
2563: oe_system_parameters_all ospa
2564: where oel.line_id = p_shipset.identifier(1)
2565: and nvl(oel.org_id,-1) = nvl(ospa.org_id,-1) --bug 1531691
2566: and oel.inventory_item_id = p_shipset.inventory_item_id(1) ;
2567: EXCEPTION