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

Line 337: INTO l_item_id FROM DUAL;

333: --User can now populate inventory item id in the interface table.
334: l_Itemid_error := FALSE;
335: BEGIN
336: SELECT MTL_SYSTEM_ITEMS_S.CURRVAL
337: INTO l_item_id FROM DUAL;
338: IF cr.inventory_item_id > l_item_id THEN
339: l_Itemid_error := TRUE;
340: END IF;
341: EXCEPTION

Line 345: INTO l_item_id FROM DUAL;

341: EXCEPTION
342: WHEN OTHERS THEN
343: --Start Bug 8259665
344: SELECT MTL_SYSTEM_ITEMS_S.NEXTVAL
345: INTO l_item_id FROM DUAL;
346: IF cr.inventory_item_id > l_item_id THEN
347: l_Itemid_error := TRUE;
348: END IF;
349: --End Bug 8259665

Line 1063: select MTL_SYSTEM_ITEMS_S.CURRVAL INTO cr.inventory_item_id FROM DUAL;

1059: update MTL_SYSTEM_ITEMS_INTERFACE
1060: set inventory_item_id = MTL_SYSTEM_ITEMS_S.nextval
1061: where rowid = cr.rowid;
1062:
1063: select MTL_SYSTEM_ITEMS_S.CURRVAL INTO cr.inventory_item_id FROM DUAL;
1064:
1065: dbms_sql.close_cursor(DSQL_c);
1066: end if; -- Row not in MSI and MSII
1067:

Line 1613: DUAL_UOM_DEVIATION_HIGH = DECODE( DUAL_UOM_DEVIATION_HIGH, g_Upd_Null_NUM,

1609: EAM_ACT_SHUTDOWN_STATUS = DECODE( EAM_ACT_SHUTDOWN_STATUS,
1610: g_Upd_Null_CHAR, NULL, trim(EAM_ACT_SHUTDOWN_STATUS) ),
1611: SECONDARY_UOM_CODE = DECODE( SECONDARY_UOM_CODE, g_Upd_Null_CHAR,
1612: NULL, trim(SECONDARY_UOM_CODE) ),
1613: DUAL_UOM_DEVIATION_HIGH = DECODE( DUAL_UOM_DEVIATION_HIGH, g_Upd_Null_NUM,
1614: NULL, DUAL_UOM_DEVIATION_HIGH ),
1615: DUAL_UOM_DEVIATION_LOW = DECODE( DUAL_UOM_DEVIATION_LOW, g_Upd_Null_NUM,
1616: NULL, DUAL_UOM_DEVIATION_LOW ),
1617: CONTRACT_ITEM_TYPE_CODE = DECODE( CONTRACT_ITEM_TYPE_CODE,

Line 1614: NULL, DUAL_UOM_DEVIATION_HIGH ),

1610: g_Upd_Null_CHAR, NULL, trim(EAM_ACT_SHUTDOWN_STATUS) ),
1611: SECONDARY_UOM_CODE = DECODE( SECONDARY_UOM_CODE, g_Upd_Null_CHAR,
1612: NULL, trim(SECONDARY_UOM_CODE) ),
1613: DUAL_UOM_DEVIATION_HIGH = DECODE( DUAL_UOM_DEVIATION_HIGH, g_Upd_Null_NUM,
1614: NULL, DUAL_UOM_DEVIATION_HIGH ),
1615: DUAL_UOM_DEVIATION_LOW = DECODE( DUAL_UOM_DEVIATION_LOW, g_Upd_Null_NUM,
1616: NULL, DUAL_UOM_DEVIATION_LOW ),
1617: CONTRACT_ITEM_TYPE_CODE = DECODE( CONTRACT_ITEM_TYPE_CODE,
1618: g_Upd_Null_CHAR, NULL, trim(CONTRACT_ITEM_TYPE_CODE) ),

Line 1615: DUAL_UOM_DEVIATION_LOW = DECODE( DUAL_UOM_DEVIATION_LOW, g_Upd_Null_NUM,

1611: SECONDARY_UOM_CODE = DECODE( SECONDARY_UOM_CODE, g_Upd_Null_CHAR,
1612: NULL, trim(SECONDARY_UOM_CODE) ),
1613: DUAL_UOM_DEVIATION_HIGH = DECODE( DUAL_UOM_DEVIATION_HIGH, g_Upd_Null_NUM,
1614: NULL, DUAL_UOM_DEVIATION_HIGH ),
1615: DUAL_UOM_DEVIATION_LOW = DECODE( DUAL_UOM_DEVIATION_LOW, g_Upd_Null_NUM,
1616: NULL, DUAL_UOM_DEVIATION_LOW ),
1617: CONTRACT_ITEM_TYPE_CODE = DECODE( CONTRACT_ITEM_TYPE_CODE,
1618: g_Upd_Null_CHAR, NULL, trim(CONTRACT_ITEM_TYPE_CODE) ),
1619: SUBSCRIPTION_DEPEND_FLAG = DECODE( SUBSCRIPTION_DEPEND_FLAG,

Line 1616: NULL, DUAL_UOM_DEVIATION_LOW ),

1612: NULL, trim(SECONDARY_UOM_CODE) ),
1613: DUAL_UOM_DEVIATION_HIGH = DECODE( DUAL_UOM_DEVIATION_HIGH, g_Upd_Null_NUM,
1614: NULL, DUAL_UOM_DEVIATION_HIGH ),
1615: DUAL_UOM_DEVIATION_LOW = DECODE( DUAL_UOM_DEVIATION_LOW, g_Upd_Null_NUM,
1616: NULL, DUAL_UOM_DEVIATION_LOW ),
1617: CONTRACT_ITEM_TYPE_CODE = DECODE( CONTRACT_ITEM_TYPE_CODE,
1618: g_Upd_Null_CHAR, NULL, trim(CONTRACT_ITEM_TYPE_CODE) ),
1619: SUBSCRIPTION_DEPEND_FLAG = DECODE( SUBSCRIPTION_DEPEND_FLAG,
1620: g_Upd_Null_CHAR, NULL, trim(SUBSCRIPTION_DEPEND_FLAG) ),