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 1198: l_Item_rec_in.DUAL_UOM_CONTROL := G_Item_Rec.DUAL_UOM_CONTROL;

1194: --PRIMARY_UNIT_OF_MEASURE
1195: l_Item_rec_in.ALLOWED_UNITS_LOOKUP_CODE := G_Item_Rec.ALLOWED_UNITS_LOOKUP_CODE;
1196: l_Item_rec_in.INVENTORY_ITEM_STATUS_CODE := G_Item_Rec.Inventory_Item_Status_Code;
1197:
1198: l_Item_rec_in.DUAL_UOM_CONTROL := G_Item_Rec.DUAL_UOM_CONTROL;
1199: l_Item_rec_in.SECONDARY_UOM_CODE := G_Item_Rec.SECONDARY_UOM_CODE;
1200: l_Item_rec_in.DUAL_UOM_DEVIATION_HIGH := G_Item_Rec.DUAL_UOM_DEVIATION_HIGH;
1201: l_Item_rec_in.DUAL_UOM_DEVIATION_LOW := G_Item_Rec.DUAL_UOM_DEVIATION_LOW;
1202: l_Item_rec_in.ITEM_TYPE := G_Item_Rec.ITEM_TYPE;

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

1196: l_Item_rec_in.INVENTORY_ITEM_STATUS_CODE := G_Item_Rec.Inventory_Item_Status_Code;
1197:
1198: l_Item_rec_in.DUAL_UOM_CONTROL := G_Item_Rec.DUAL_UOM_CONTROL;
1199: l_Item_rec_in.SECONDARY_UOM_CODE := G_Item_Rec.SECONDARY_UOM_CODE;
1200: l_Item_rec_in.DUAL_UOM_DEVIATION_HIGH := G_Item_Rec.DUAL_UOM_DEVIATION_HIGH;
1201: l_Item_rec_in.DUAL_UOM_DEVIATION_LOW := G_Item_Rec.DUAL_UOM_DEVIATION_LOW;
1202: l_Item_rec_in.ITEM_TYPE := G_Item_Rec.ITEM_TYPE;
1203:
1204: -- Inventory

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

1197:
1198: l_Item_rec_in.DUAL_UOM_CONTROL := G_Item_Rec.DUAL_UOM_CONTROL;
1199: l_Item_rec_in.SECONDARY_UOM_CODE := G_Item_Rec.SECONDARY_UOM_CODE;
1200: l_Item_rec_in.DUAL_UOM_DEVIATION_HIGH := G_Item_Rec.DUAL_UOM_DEVIATION_HIGH;
1201: l_Item_rec_in.DUAL_UOM_DEVIATION_LOW := G_Item_Rec.DUAL_UOM_DEVIATION_LOW;
1202: l_Item_rec_in.ITEM_TYPE := G_Item_Rec.ITEM_TYPE;
1203:
1204: -- Inventory
1205: l_Item_rec_in.INVENTORY_ITEM_FLAG := G_Item_Rec.INVENTORY_ITEM_FLAG;

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

5197: l_new_itemgen_sql := l_new_itemgen_sql || ' SELECT ';
5198: l_new_itemgen_sql := l_new_itemgen_sql ||''''|| l_itemgen_prefix_table(l_itemgen_rownum) || ''' || ';
5199: l_new_itemgen_sql := l_new_itemgen_sql || l_itemgen_seq_table(l_itemgen_rownum) || '.NEXTVAL || ';
5200: l_new_itemgen_sql := l_new_itemgen_sql ||''''|| l_itemgen_suffix_table(l_itemgen_rownum)||'''';
5201: l_new_itemgen_sql := l_new_itemgen_sql || ' FROM DUAL ';
5202:
5203: --DBMS_OUTPUT.PUT_LINE('l_new_itemgen_sql => '||l_new_itemgen_sql);
5204: EXECUTE IMMEDIATE l_new_itemgen_sql INTO l_item_num;
5205:

Line 6169: FROM dual) A

6165: ,A.ITEM_CATALOG_GROUP_ID ITEM_CATALOG_GROUP_ID
6166: ,A.OBJECT_NAME OBJECT_NAME
6167: ,A.ATTRIBUTE_GROUP_TYPE ATTRIBUTE_GROUP_TYPE
6168: FROM THE (SELECT CAST(p_item_attr_def_tab AS "SYSTEM".EGO_ITEM_ATTR_DEFAULT_TABLE)
6169: FROM dual) A
6170: ORDER BY INVENTORY_ITEM_ID;
6171:
6172: BEGIN
6173: x_return_status := l_return_status;

Line 6437: from dual

6433:
6434: BEGIN
6435: select 'Y'
6436: into l_exists
6437: from dual
6438: where exists( select 1
6439: from mtl_material_transactions_temp
6440: where organization_id = p_organization_id
6441: and inventory_item_id = p_inventory_item_id

Line 6459: from dual

6455:
6456: BEGIN
6457: select 'Y'
6458: into l_exists
6459: from dual
6460: where exists( select 1
6461: from mtl_material_transactions_temp
6462: where organization_id = p_organization_id
6463: and inventory_item_id = p_inventory_item_id