DBA Data[Home] [Help]

APPS.MSC_ATP_PROC dependencies on MSC_UOM_CONVERSIONS_VIEW

Line 2154: FROM msc_uom_conversions_view mucv,

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

Line 2173: FROM msc_uom_conversions_view mucv

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