DBA Data[Home] [Help]

APPS.MSC_BUDGET_DETAILS dependencies on MSC_SYSTEM_ITEMS

Line 39: msc_system_items item

35: select bid.inventory_item_id,
36: bid.inventory_value,
37: bid.inventory_value/l_tot_inv
38: from msc_bis_inv_detail bid ,
39: msc_system_items item
40: where nvl(bid.period_type,-1)=1
41: and bid.detail_date = l_date
42: and bid.plan_id = p_plan_id
43: and nvl(bid.detail_level,3) = nvl(l_bucket_type,3)

Line 59: msc_system_items item

55: select bid.inventory_item_id,
56: bid.inventory_value,
57: bid.inventory_value/l_tot_inv
58: from msc_bis_inv_detail bid,
59: msc_system_items item
60: where nvl(bid.period_type,-1)=1
61: and bid.detail_date = l_date
62: and bid.plan_id = p_plan_id
63: and bid.organization_id=l_organization_id

Line 82: msc_system_items item

78: bid.inventory_value,
79: bid.inventory_value/l_tot_inv
80: from msc_bis_inv_detail bid,
81: msc_item_categories mic,
82: msc_system_items item
83: where nvl(bid.period_type,-1)=1
84: and bid.detail_date = l_date
85: and bid.plan_id = p_plan_id
86: and nvl(bid.detail_level,3) = nvl(l_bucket_type,3)