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 325: INTO l_item_id FROM DUAL;

321: --User can now populate inventory item id in the interface table.
322: l_Itemid_error := FALSE;
323: BEGIN
324: SELECT MTL_SYSTEM_ITEMS_S.CURRVAL
325: INTO l_item_id FROM DUAL;
326: IF cr.inventory_item_id > l_item_id THEN
327: l_Itemid_error := TRUE;
328: END IF;
329: EXCEPTION

Line 1518: DUAL_UOM_DEVIATION_HIGH = DECODE( DUAL_UOM_DEVIATION_HIGH, g_Upd_Null_NUM,

1514: EAM_ACT_SHUTDOWN_STATUS = DECODE( EAM_ACT_SHUTDOWN_STATUS,
1515: g_Upd_Null_CHAR, NULL, trim(EAM_ACT_SHUTDOWN_STATUS) ),
1516: SECONDARY_UOM_CODE = DECODE( SECONDARY_UOM_CODE, g_Upd_Null_CHAR,
1517: NULL, trim(SECONDARY_UOM_CODE) ),
1518: DUAL_UOM_DEVIATION_HIGH = DECODE( DUAL_UOM_DEVIATION_HIGH, g_Upd_Null_NUM,
1519: NULL, DUAL_UOM_DEVIATION_HIGH ),
1520: DUAL_UOM_DEVIATION_LOW = DECODE( DUAL_UOM_DEVIATION_LOW, g_Upd_Null_NUM,
1521: NULL, DUAL_UOM_DEVIATION_LOW ),
1522: CONTRACT_ITEM_TYPE_CODE = DECODE( CONTRACT_ITEM_TYPE_CODE,

Line 1519: NULL, DUAL_UOM_DEVIATION_HIGH ),

1515: g_Upd_Null_CHAR, NULL, trim(EAM_ACT_SHUTDOWN_STATUS) ),
1516: SECONDARY_UOM_CODE = DECODE( SECONDARY_UOM_CODE, g_Upd_Null_CHAR,
1517: NULL, trim(SECONDARY_UOM_CODE) ),
1518: DUAL_UOM_DEVIATION_HIGH = DECODE( DUAL_UOM_DEVIATION_HIGH, g_Upd_Null_NUM,
1519: NULL, DUAL_UOM_DEVIATION_HIGH ),
1520: DUAL_UOM_DEVIATION_LOW = DECODE( DUAL_UOM_DEVIATION_LOW, g_Upd_Null_NUM,
1521: NULL, DUAL_UOM_DEVIATION_LOW ),
1522: CONTRACT_ITEM_TYPE_CODE = DECODE( CONTRACT_ITEM_TYPE_CODE,
1523: g_Upd_Null_CHAR, NULL, trim(CONTRACT_ITEM_TYPE_CODE) ),

Line 1520: DUAL_UOM_DEVIATION_LOW = DECODE( DUAL_UOM_DEVIATION_LOW, g_Upd_Null_NUM,

1516: SECONDARY_UOM_CODE = DECODE( SECONDARY_UOM_CODE, g_Upd_Null_CHAR,
1517: NULL, trim(SECONDARY_UOM_CODE) ),
1518: DUAL_UOM_DEVIATION_HIGH = DECODE( DUAL_UOM_DEVIATION_HIGH, g_Upd_Null_NUM,
1519: NULL, DUAL_UOM_DEVIATION_HIGH ),
1520: DUAL_UOM_DEVIATION_LOW = DECODE( DUAL_UOM_DEVIATION_LOW, g_Upd_Null_NUM,
1521: NULL, DUAL_UOM_DEVIATION_LOW ),
1522: CONTRACT_ITEM_TYPE_CODE = DECODE( CONTRACT_ITEM_TYPE_CODE,
1523: g_Upd_Null_CHAR, NULL, trim(CONTRACT_ITEM_TYPE_CODE) ),
1524: SUBSCRIPTION_DEPEND_FLAG = DECODE( SUBSCRIPTION_DEPEND_FLAG,

Line 1521: NULL, DUAL_UOM_DEVIATION_LOW ),

1517: NULL, trim(SECONDARY_UOM_CODE) ),
1518: DUAL_UOM_DEVIATION_HIGH = DECODE( DUAL_UOM_DEVIATION_HIGH, g_Upd_Null_NUM,
1519: NULL, DUAL_UOM_DEVIATION_HIGH ),
1520: DUAL_UOM_DEVIATION_LOW = DECODE( DUAL_UOM_DEVIATION_LOW, g_Upd_Null_NUM,
1521: NULL, DUAL_UOM_DEVIATION_LOW ),
1522: CONTRACT_ITEM_TYPE_CODE = DECODE( CONTRACT_ITEM_TYPE_CODE,
1523: g_Upd_Null_CHAR, NULL, trim(CONTRACT_ITEM_TYPE_CODE) ),
1524: SUBSCRIPTION_DEPEND_FLAG = DECODE( SUBSCRIPTION_DEPEND_FLAG,
1525: g_Upd_Null_CHAR, NULL, trim(SUBSCRIPTION_DEPEND_FLAG) ),