DBA Data[Home] [Help]

APPS.MSC_SNO_PKG dependencies on STANDARD

Line 130: 160, abs(t.quantity) *msi.standard_cost,

126: sum(decode(t.exception_type,
127: 150, abs(t.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
128: 151, t.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
129: 152, t.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
130: 160, abs(t.quantity) *msi.standard_cost,
131: 161, t.quantity *msi.standard_cost,
132: 162, t.quantity *msi.standard_cost,
133: 190, abs(t.quantity) *msi.standard_cost,
134: 191, t.quantity *msi.standard_cost,

Line 131: 161, t.quantity *msi.standard_cost,

127: 150, abs(t.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
128: 151, t.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
129: 152, t.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
130: 160, abs(t.quantity) *msi.standard_cost,
131: 161, t.quantity *msi.standard_cost,
132: 162, t.quantity *msi.standard_cost,
133: 190, abs(t.quantity) *msi.standard_cost,
134: 191, t.quantity *msi.standard_cost,
135: to_number(null)) )exception_value, -- wei: SNO

Line 132: 162, t.quantity *msi.standard_cost,

128: 151, t.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
129: 152, t.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
130: 160, abs(t.quantity) *msi.standard_cost,
131: 161, t.quantity *msi.standard_cost,
132: 162, t.quantity *msi.standard_cost,
133: 190, abs(t.quantity) *msi.standard_cost,
134: 191, t.quantity *msi.standard_cost,
135: to_number(null)) )exception_value, -- wei: SNO
136: to_number(null) exception_days, -- wei: SNO always null

Line 133: 190, abs(t.quantity) *msi.standard_cost,

129: 152, t.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
130: 160, abs(t.quantity) *msi.standard_cost,
131: 161, t.quantity *msi.standard_cost,
132: 162, t.quantity *msi.standard_cost,
133: 190, abs(t.quantity) *msi.standard_cost,
134: 191, t.quantity *msi.standard_cost,
135: to_number(null)) )exception_value, -- wei: SNO
136: to_number(null) exception_days, -- wei: SNO always null
137: sum(decode( t.exception_type,

Line 134: 191, t.quantity *msi.standard_cost,

130: 160, abs(t.quantity) *msi.standard_cost,
131: 161, t.quantity *msi.standard_cost,
132: 162, t.quantity *msi.standard_cost,
133: 190, abs(t.quantity) *msi.standard_cost,
134: 191, t.quantity *msi.standard_cost,
135: to_number(null)) )exception_value, -- wei: SNO
136: to_number(null) exception_days, -- wei: SNO always null
137: sum(decode( t.exception_type,
138: 150, abs(t.quantity),