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

Line 994: l_Item_rec_in.DUAL_UOM_CONTROL := G_Item_Rec.DUAL_UOM_CONTROL;

990: --PRIMARY_UNIT_OF_MEASURE
991: l_Item_rec_in.ALLOWED_UNITS_LOOKUP_CODE := G_Item_Rec.ALLOWED_UNITS_LOOKUP_CODE;
992: l_Item_rec_in.INVENTORY_ITEM_STATUS_CODE := G_Item_Rec.Inventory_Item_Status_Code;
993:
994: l_Item_rec_in.DUAL_UOM_CONTROL := G_Item_Rec.DUAL_UOM_CONTROL;
995: l_Item_rec_in.SECONDARY_UOM_CODE := G_Item_Rec.SECONDARY_UOM_CODE;
996: l_Item_rec_in.DUAL_UOM_DEVIATION_HIGH := G_Item_Rec.DUAL_UOM_DEVIATION_HIGH;
997: l_Item_rec_in.DUAL_UOM_DEVIATION_LOW := G_Item_Rec.DUAL_UOM_DEVIATION_LOW;
998: l_Item_rec_in.ITEM_TYPE := G_Item_Rec.ITEM_TYPE;

Line 996: l_Item_rec_in.DUAL_UOM_DEVIATION_HIGH := G_Item_Rec.DUAL_UOM_DEVIATION_HIGH;

992: l_Item_rec_in.INVENTORY_ITEM_STATUS_CODE := G_Item_Rec.Inventory_Item_Status_Code;
993:
994: l_Item_rec_in.DUAL_UOM_CONTROL := G_Item_Rec.DUAL_UOM_CONTROL;
995: l_Item_rec_in.SECONDARY_UOM_CODE := G_Item_Rec.SECONDARY_UOM_CODE;
996: l_Item_rec_in.DUAL_UOM_DEVIATION_HIGH := G_Item_Rec.DUAL_UOM_DEVIATION_HIGH;
997: l_Item_rec_in.DUAL_UOM_DEVIATION_LOW := G_Item_Rec.DUAL_UOM_DEVIATION_LOW;
998: l_Item_rec_in.ITEM_TYPE := G_Item_Rec.ITEM_TYPE;
999:
1000: -- Inventory

Line 997: l_Item_rec_in.DUAL_UOM_DEVIATION_LOW := G_Item_Rec.DUAL_UOM_DEVIATION_LOW;

993:
994: l_Item_rec_in.DUAL_UOM_CONTROL := G_Item_Rec.DUAL_UOM_CONTROL;
995: l_Item_rec_in.SECONDARY_UOM_CODE := G_Item_Rec.SECONDARY_UOM_CODE;
996: l_Item_rec_in.DUAL_UOM_DEVIATION_HIGH := G_Item_Rec.DUAL_UOM_DEVIATION_HIGH;
997: l_Item_rec_in.DUAL_UOM_DEVIATION_LOW := G_Item_Rec.DUAL_UOM_DEVIATION_LOW;
998: l_Item_rec_in.ITEM_TYPE := G_Item_Rec.ITEM_TYPE;
999:
1000: -- Inventory
1001: l_Item_rec_in.INVENTORY_ITEM_FLAG := G_Item_Rec.INVENTORY_ITEM_FLAG;

Line 4705: l_new_itemgen_sql := l_new_itemgen_sql || ' FROM DUAL ';

4701: l_new_itemgen_sql := l_new_itemgen_sql || ' SELECT ';
4702: l_new_itemgen_sql := l_new_itemgen_sql ||''''|| l_itemgen_prefix_table(l_itemgen_rownum) || ''' || ';
4703: l_new_itemgen_sql := l_new_itemgen_sql || l_itemgen_seq_table(l_itemgen_rownum) || '.NEXTVAL || ';
4704: l_new_itemgen_sql := l_new_itemgen_sql ||''''|| l_itemgen_suffix_table(l_itemgen_rownum)||'''';
4705: l_new_itemgen_sql := l_new_itemgen_sql || ' FROM DUAL ';
4706:
4707: --DBMS_OUTPUT.PUT_LINE('l_new_itemgen_sql => '||l_new_itemgen_sql);
4708: EXECUTE IMMEDIATE l_new_itemgen_sql INTO l_item_num;
4709:

Line 5654: FROM dual) A

5650: ,A.ITEM_CATALOG_GROUP_ID ITEM_CATALOG_GROUP_ID
5651: ,A.OBJECT_NAME OBJECT_NAME
5652: ,A.ATTRIBUTE_GROUP_TYPE ATTRIBUTE_GROUP_TYPE
5653: FROM THE (SELECT CAST(p_item_attr_def_tab AS "SYSTEM".EGO_ITEM_ATTR_DEFAULT_TABLE)
5654: FROM dual) A
5655: ORDER BY INVENTORY_ITEM_ID;
5656:
5657: BEGIN
5658: x_return_status := l_return_status;