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

Line 865: FROM dual;

861: l_Rel_Item_Rec.Attr_Date7, l_Rel_Item_Rec.Attr_Date8, l_Rel_Item_Rec.Attr_Date9, l_Rel_Item_Rec.Attr_Date10,
862: l_Rel_Item_Rec.Planning_Enabled_Flag--, l_Rel_Item_Rec.Last_Update_Date, l_Rel_Item_Rec.Last_Updated_By,
863: --l_Rel_Item_Rec.Creation_Date,l_Rel_Item_Rec.Created_By, l_Rel_Item_Rec.Last_Update_Login
864:
865: FROM dual;
866:
867: Write_Debug('Creating Related Item record...');
868:
869: MTL_RELATED_ITEMS_PKG.INSERT_ROW(

Line 1033: FROM dual;

1029: L_REL_ITEM_REC.ATTR_DATE7, L_REL_ITEM_REC.ATTR_DATE8, L_REL_ITEM_REC.ATTR_DATE9, L_REL_ITEM_REC.ATTR_DATE10,
1030: l_Rel_Item_Rec.Planning_Enabled_Flag--, l_Rel_Item_Rec.Last_Update_Date, l_Rel_Item_Rec.Last_Updated_By,
1031: -- l_Rel_Item_Rec.Creation_Date,l_Rel_Item_Rec.Created_By, l_Rel_Item_Rec.Last_Update_Login
1032:
1033: FROM dual;
1034:
1035: --*** to check for duplicate record?
1036:
1037: IF

Line 1397: FROM dual;

1393: INTO l_Pln_Info_Rec.Inventory_Item_Id,l_Pln_Info_Rec.Organization_Id,l_Pln_Info_Rec.Related_Item_Id,
1394: l_Pln_Info_Rec.Relationship_Type_Id,l_Pln_Info_Rec.Substitution_Set,l_Pln_Info_Rec.Partial_Fulfillment_Flag,
1395: l_Pln_Info_Rec.Start_Date,l_Pln_Info_Rec.End_Date,l_Pln_Info_Rec.All_Customers_Flag
1396:
1397: FROM dual;
1398: End;
1399: END IF;
1400:
1401: IF l_Pln_Info_Rec.TRANSACTION_TYPE = 'UPDATE' THEN

Line 1455: FROM dual;

1451: Decode(l_Pln_Info_Rec.All_Customers_Flag,FND_API.G_MISS_CHAR, l_mtl_Rel_Item_Pln_Info_rec.All_Customers_Flag, l_Pln_Info_Rec.All_Customers_Flag)
1452: INTO l_Pln_Info_Rec.Inventory_Item_Id,l_Pln_Info_Rec.Organization_Id,l_Pln_Info_Rec.Related_Item_Id,l_Pln_Info_Rec.Relationship_Type_Id,
1453: l_Pln_Info_Rec.Substitution_Set,l_Pln_Info_Rec.Partial_Fulfillment_Flag,l_Pln_Info_Rec.Start_Date,l_Pln_Info_Rec.End_Date,
1454: l_Pln_Info_Rec.All_Customers_Flag
1455: FROM dual;
1456: END;
1457: END IF;
1458:
1459: -- planning info/ substitution set date validation --

Line 1706: FROM dual;

1702: INTO l_Cust_Ref_Rec.Pln_Info_Id,l_Cust_Ref_Rec.Inventory_Item_Id,l_Cust_Ref_Rec.Organization_Id,l_Cust_Ref_Rec.Related_Item_Id,
1703: l_Cust_Ref_Rec.Relationship_Type_Id,l_Cust_Ref_Rec.Customer_Id,l_Cust_Ref_Rec.Site_Use_Id,
1704: l_Cust_Ref_Rec.Start_Date,l_Cust_Ref_Rec.End_Date
1705:
1706: FROM dual;
1707:
1708: -- checking if customer and site combinations already exists
1709: SELECT 'x' INTO l_cust_ref_exists
1710: FROM mtl_related_items_cust_ref

Line 1798: FROM dual;

1794: Decode(l_Cust_Ref_Rec.Start_Date,FND_API.G_MISS_DATE, l_mtl_Rel_Item_Cust_Ref_rec.Start_Date, l_Cust_Ref_Rec.Start_Date),
1795: Decode(l_Cust_Ref_Rec.End_Date,FND_API.G_MISS_DATE, l_mtl_Rel_Item_Cust_Ref_rec.End_Date, l_Cust_Ref_Rec.End_Date)
1796: Into l_Cust_Ref_Rec.Inventory_Item_Id,l_Cust_Ref_Rec.Organization_Id,l_Cust_Ref_Rec.Related_Item_Id,l_Cust_Ref_Rec.Relationship_Type_Id,
1797: l_Cust_Ref_Rec.Pln_Info_Id,l_Cust_Ref_Rec.Customer_Id,l_Cust_Ref_Rec.Site_Use_Id,l_Cust_Ref_Rec.Start_Date,l_Cust_Ref_Rec.End_Date
1798: FROM dual;
1799: END;
1800:
1801: END IF;
1802: