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.OE_QUERY dependencies on MTL_DEMAND_INTERFACE

Line 1548: From MTL_Demand_Interface

1544: L_ATP_Date Date;
1545: Begin
1546: Select NVL(Min(Group_Available_Date), Min(Request_ATP_Date))
1547: Into L_ATP_Date
1548: From MTL_Demand_Interface
1549: Where Session_Id = P_Session_Id
1550: And Demand_Source_Line = P_Line_Id
1551: And Inventory_Item_Id = P_Inventory_Item_Id
1552: And N_Column4 is Null

Line 1574: From MTL_Demand_Interface

1570: L_Available_Qty Number;
1571: Begin
1572: Select Min(Request_Date_ATP_Quantity)
1573: Into L_Available_Qty
1574: From MTL_Demand_Interface
1575: Where Session_Id = P_Session_Id
1576: And Demand_Source_Line = P_Line_Id
1577: And Inventory_Item_Id = P_Inventory_Item_Id
1578: And Line_Item_Quantity > 0

Line 1597: From MTL_Demand_Interface

1593: L_Demand_Interface_RowId Varchar2(30);
1594: Begin
1595: Select Min(RowIdtoChar(RowId))
1596: Into L_Demand_Interface_RowId
1597: From MTL_Demand_Interface
1598: Where Session_Id = P_Session_Id
1599: And Demand_Source_Line = P_Line_Id
1600: And N_Column4 is Null
1601: And Line_Item_Quantity <> 0

Line 1620: From MTL_Demand_Interface

1616: L_ATP_Date Date;
1617: Begin
1618: Select NVL(Min(Group_Available_Date), Min(Request_ATP_Date))
1619: Into L_ATP_Date
1620: From MTL_Demand_Interface
1621: Where Session_Id = P_Session_Id
1622: And Demand_Source_Delivery = P_Delivery
1623: And N_Column4 is Null
1624: Having Count(Distinct Group_Available_Date) = 1

Line 1644: From MTL_Demand_Interface

1640: L_Available_Qty Number;
1641: Begin
1642: Select Min(Request_Date_ATP_Quantity)
1643: Into L_Available_Qty
1644: From MTL_Demand_Interface
1645: Where Session_Id = P_Session_Id
1646: And Demand_Source_Delivery = P_Delivery
1647: And Line_Item_Quantity > 0
1648: And N_Column4 is Null

Line 1666: From MTL_Demand_Interface

1662: L_Demand_Interface_RowId Varchar2(30);
1663: Begin
1664: Select Min(RowIdtoChar(RowId))
1665: Into L_Demand_Interface_RowId
1666: From MTL_Demand_Interface
1667: Where Session_Id = P_Session_Id
1668: And Demand_Source_Line = P_Delivery
1669: And N_Column4 is Null
1670: And Line_Item_Quantity <> 0