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.FLM_SUPPLY_DEMAND dependencies on DUAL

Line 215: This procedure is a wrapper to collect all the individual supply types.

211: END Collect_Supply_Demand_Info;
212:
213:
214: /*
215: This procedure is a wrapper to collect all the individual supply types.
216: */
217: PROCEDURE Collect_Supply_Info(p_group_id IN NUMBER,
218: p_sys_seq_num IN NUMBER,
219: p_mrp_status IN NUMBER,

Line 283: This procedure is a wrapper to collect all the individual demand types.

279: END Collect_Supply_Info;
280:
281:
282: /*
283: This procedure is a wrapper to collect all the individual demand types.
284: */
285: PROCEDURE Collect_Demand_Info(p_group_id IN NUMBER,
286: p_sys_seq_num IN NUMBER,
287: p_mrp_status IN NUMBER,

Line 336: -- The procedures to collect individual supply/demand information follow.

332:
333:
334:
335: --
336: -- The procedures to collect individual supply/demand information follow.
337: --
338:
339:
340: PROCEDURE Collect_OnHand_Supply(p_group_id IN NUMBER,

Line 1577: FROM DUAL;

1573: BEGIN
1574:
1575: SELECT OE_INSTALL.Get_Active_Product
1576: INTO l_oe_install
1577: FROM DUAL;
1578:
1579: IF l_oe_install = 'OE' THEN
1580: OPEN OE_SALESORDER_DEMAND_CURSOR;
1581:

Line 1777: SELECT MTL_ATP_RULES_S.NEXTVAL,MTL_SUPPLY_DEMAND_TEMP_S.NEXTVAL INTO l_rule_id,l_group_id from DUAL;

1773: l_debug_line := 10;
1774: x_return_status := FND_API.G_RET_STS_SUCCESS;
1775:
1776: -- Preparing the init data
1777: SELECT MTL_ATP_RULES_S.NEXTVAL,MTL_SUPPLY_DEMAND_TEMP_S.NEXTVAL INTO l_rule_id,l_group_id from DUAL;
1778: DELETE FROM MTL_ATP_RULES WHERE RULE_NAME = 'FLM';
1779:
1780: l_debug_line := 20;
1781: