eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_BUDGET_DETAILS dependencies on MSC_SAFETY_STOCKS

Line 97: cursor ss_date_c(l_inventory_item_id1 number, -- get the date to use in msc_safety_stocks

93: and bid.organization_id = item.organization_id
94: and bid.inventory_item_id = item.inventory_item_id
95: and item.budget_constrained =1;
96:
97: cursor ss_date_c(l_inventory_item_id1 number, -- get the date to use in msc_safety_stocks
98: l_organization_id1 number,
99: l_sr_instance_id1 number,
100: l_plan_id1 number,
101: l_detail_date1 date) is

Line 103: from msc_safety_stocks

99: l_sr_instance_id1 number,
100: l_plan_id1 number,
101: l_detail_date1 date) is
102: select max(period_start_date)
103: from msc_safety_stocks
104: where period_start_date <= l_detail_date1
105: and inventory_item_id = l_inventory_item_id1
106: and organization_id = l_organization_id1
107: and sr_instance_id = l_sr_instance_id1

Line 111: cursor safety_stocks_c (l_inventory_item_id number, -- get the values from msc_safety_stocks

107: and sr_instance_id = l_sr_instance_id1
108: and plan_id = l_plan_id1;
109:
110:
111: cursor safety_stocks_c (l_inventory_item_id number, -- get the values from msc_safety_stocks
112: l_organization_id number,
113: l_sr_instance_id number,
114: l_plan_id number,
115: l_period_start_date date) is

Line 117: from msc_safety_stocks

113: l_sr_instance_id number,
114: l_plan_id number,
115: l_period_start_date date) is
116: select target_safety_stock, safety_stock_quantity
117: from msc_safety_stocks
118: where inventory_item_id = l_inventory_item_id
119: and organization_id= l_organization_id
120: and sr_instance_id = l_sr_instance_id
121: and plan_id = l_plan_id