DBA Data[Home] [Help]

APPS.MSC_ATP_PROC dependencies on MSC_UOM_CONVERSIONS_VIEW

Line 2153: FROM msc_uom_conversions_view mucv,

2149: SELECT items.uom_code,
2150: conversion_rate
2151: INTO x_primary_uom_code,
2152: x_conversion_rate
2153: FROM msc_uom_conversions_view mucv,
2154: msc_system_items items
2155: WHERE items.sr_inventory_item_id = p_inventory_item_id
2156: AND items.organization_id = p_organization_id
2157: AND items.plan_id = -1

Line 2172: FROM msc_uom_conversions_view mucv

2168: SELECT primary_uom_code,
2169: conversion_rate
2170: INTO x_primary_uom_code,
2171: x_conversion_rate
2172: FROM msc_uom_conversions_view mucv
2173: WHERE mucv.uom_code = p_uom_code
2174: AND mucv.primary_uom_code = MSC_ATP_PVT.G_ITEM_INFO_REC.uom_code
2175: AND mucv.inventory_item_id = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id
2176: AND mucv.organization_id = p_organization_id